Public Forums 71,145 posts

[manhlienhuong Friend manhlienhuongJoin date: September 2011Posts: 3Downloads:0Uploads:0 Thanks: 2]

#169163

hi everybody
I installing JA JOBBOARD it this error message:

* JInstaller::install: SQL Error. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM AUTO_INCREMENT=31’ at line 18 SQL=– — Table structure for table `jos_ja_applications` — CREATE TABLE IF NOT EXISTS `jos_ja_applications` ( `id` int(11) NOT NULL auto_increment, `subject` varchar(255) default NULL, `resume_id` int(11) default NULL, `job_id` int(11) NOT NULL, `message` mediumtext, `views` int(11) default NULL, `user_id` int(11) default NULL, `attachment` varchar(255) default NULL, `created_date` datetime default NULL, `guest_name` varchar(255) default NULL, `guest_email` varchar(255) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=31 ;
SQL =

—
— Table structure for table `jos_ja_applications`
—

CREATE TABLE IF NOT EXISTS `jos_ja_applications` (
`id` int(11) NOT NULL auto_increment,
`subject` varchar(255) default NULL,
`resume_id` int(11) default NULL,
`job_id` int(11) NOT NULL,
`message` mediumtext,
`views` int(11) default NULL,
`user_id` int(11) default NULL,
`attachment` varchar(255) default NULL,
`created_date` datetime default NULL,
`guest_name` varchar(255) default NULL,
`guest_email` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=31 ;

* Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM AUTO_INCREMENT=31’ at line 18 SQL=– — Table structure for table `jos_ja_applications` — CREATE TABLE IF NOT EXISTS `jos_ja_applications` ( `id` int(11) NOT NULL auto_increment, `subject` varchar(255) default NULL, `resume_id` int(11) default NULL, `job_id` int(11) NOT NULL, `message` mediumtext, `views` int(11) default NULL, `user_id` int(11) default NULL, `attachment` varchar(255) default NULL, `created_date` datetime default NULL, `guest_name` varchar(255) default NULL, `guest_email` varchar(255) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=31 ;
SQL =

—
— Table structure for table `jos_ja_applications`
—

CREATE TABLE IF NOT EXISTS `jos_ja_applications` (
`id` int(11) NOT NULL auto_increment,
`subject` varchar(255) default NULL,
`resume_id` int(11) default NULL,
`job_id` int(11) NOT NULL,
`message` mediumtext,
`views` int(11) default NULL,
`user_id` int(11) default NULL,
`attachment` varchar(255) default NULL,
`created_date` datetime default NULL,
`guest_name` varchar(255) default NULL,
`guest_email` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=31 ;

please anyone help, thanks

[Laura Rubino Friend Laura RubinoJoin date: September 2014Posts: 86Downloads:0Uploads:0 Thanks: 2 Thanked: 15 times in 14 posts]

#416053

Please download the files again and if its a tgz please extract it and upload the extracted version

Cheers!

1 user says Thank You to Laura Rubino for this useful post

1. manhlienhuong

[manhlienhuong Friend manhlienhuongJoin date: September 2011Posts: 3Downloads:0Uploads:0 Thanks: 2]

#416190

thank you very much:)

[Laura Rubino Friend Laura RubinoJoin date: September 2014Posts: 86Downloads:0Uploads:0 Thanks: 2 Thanked: 15 times in 14 posts]

#416215

you are welcome 🙂

[manhlienhuong Friend manhlienhuongJoin date: September 2011Posts: 3Downloads:0Uploads:0 Thanks: 2]

#416222

hi makegoodmedia
I installed JA JOBBARB but that is not installed it at all, not uploadfile be, so what to do, please help me

[devcre Friend devcreJoin date: January 2012Posts: 3Downloads:0Uploads:0]

#444910

I have a similar problem. I have purchased the ja club membership. I want the Job Board Component Demo as downloadable format so that I can install into my server and show my client before purchasing the component.
It was earlier available for download………. Kindly reply soon.

[Author]

Posts