- 15 May 2008, 20:11
#178
and 0.9.1 installation error
I had previously installed and used v.8 successfully. But when I tried a fresh install of v.9 I my install went smoothly until I was prompted to start the app, and that's when I go a page full of errors - apparently having to do with SQL tables. I tried to upgrade my .8 version to v.91 (using the release candidate supplied somewhere in the forum, but I got the same errors. Can someone help me please. My vital stats are - WAMP, MySQL5, PHP5.... Here's the offending transcript:
Query Error -- Report to System Administrator ASAP
MySQL Query Failed: 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 ';
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Left', ''' at line 1
DELETE FROM `career_portal_template`;
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Left', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Footer', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Header', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Main', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'CSS', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Search Results', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Questionnaire', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Job Details', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Thanks for your Submission', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Apply for Position', '');
INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Left', '');
INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Footer', '');
INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Header', '
\r\n
IMAGE: CATS Applicant Tracking System Careers Page
\r\n
\r\n
Shortcuts:
\r\n IMAGE: Return to Main\r\nIMAGE: RSS Feed\r\n IMAGE: Show All Jobs\r\n
'); INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Content - Main', '
\r\n
Available Openings at
\r\n
\r\n
Re: 0.9.1 installation error
Did this error occur in 0.9.1 as well? I believe this was remedied in that version. Otherwise, a quick fix would be to execute the following queries in MySQL:
ALTER TABLE `attachment` ADD COLUMN `stored_on_s3` tinyint(1) default 0;
ALTER TABLE `attachment` ADD COLUMN `stored_locally` tinyint(1) default 0;
--
Re: 0.9.1 installation error
...yes the error did occur in 0.9.1. I applied the fix as you suggested and the problem is solved.
Thanks
Jos