Mysql Version???? cant install dolphin since upgrade mysql to 4.1.22

totallyfreak posted 3rd of March 2008 in Community Voice. 8 comments.
Please help!!! i cant use dolphin anymore since by mistake i upgrade my mysql version in my WHM panel on my vps account.... what i need to do for making dolphin work again..... i even cant install it...

i got this error while the installation is in progress...

Error while executing: CREATE TABLE `AccountCompose` (`ID` int(8) unsigned NOT NULL auto_increment,`Title` varchar(255) NOT NULL default '''',`Div` varchar(255) NOT NULL default '''',`Caption` varchar(255) NOT NULL default '''',`Desc` varchar(255) NOT NULL default '''',`Func` varchar(40) NOT NULL default '''',`Content` text NOT NULL,`Visible` set(''non'',''memb'') NOT NULL default '''',`Column` int(11) NOT NULL default ''0'',`Order` int(11) NOT NULL default ''0'',PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
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 'non'',''memb'') NOT NULL default '''',`Column` int(11) NOT NULL default ''0'',`O' at line 1
Error while executing: INSERT INTO `AccountCompose` VALUES (1, ''My Photos'', ''my_photos'', ''_My Photos'', '''', ''MyPhotos'', '''', '''', 1, 0);
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 'My Photos'', ''my_photos'', ''_My Photos'', '''', ''MyPhotos'', '''', '''', 1, 0' at line 1
Error while executing: INSERT INTO `AccountCompose` VALUES (2, ''Site Stats'', ''member_stat'', ''_Site Stats'', '''', ''MembersStats'', '''', '''', 1, 1);
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 'Site Stats'', ''member_stat'', ''_Site Stats'', '''', ''MembersStats'', '''', ''' at line 1
Error while executing: INSERT INTO `AccountCompose` VALUES (3, ''Member Info'', ''member_info'', ''_member info'', '''', ''MemberInfo'', '''', '''', 2, 0);
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 'Member Info'', ''member_info'', ''_member info'', '''', ''MemberInfo'', '''', ''' at line 1
Error while executing: INSERT INTO `AccountCompose` VALUES (4, ''Contacts'', ''contacts'', ''_contacts'', '''', ''Contacts'', '''', '''', 2, 1);
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 'Contacts'', ''contacts'', ''_contacts'', '''', ''Contacts'', '''', '''', 2, 1)' at line 1
Error while executing: INSERT INTO `AccountCompose` VALUES (5, ''Latest News'', ''latest_news'', ''_latest news'', '''', ''News'', '''', '''', 2, 2);
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 'Latest News'', ''latest_news'', ''_latest news'', '''', ''News'', '''', '''', 2,' at line 1



etc.........


so please help!!!
 
Comments
·Oldest
·Top
Please login to post a comment.
djgenesis
I am about to post a blog with this fix hold tight.
VictorT
Well, we can't say exactly where the problem is.

Can you send me access details to your server via PM here at unity?

We will look and help you in resolving this.
totallyfreak
ok thx for your help VictorT
DosDawg
did this get resolved? i am updating mysql tonight as well as php, apache and a few other needed updates. hope this doesnt blow up the sites i have installed?

later,
DosDawg
josesan311
Hello, im getting an error while trying to downgrade my database (my 6.1 upgrade went wrong) to the previous one because my site is not working any more.

# mysql -uuser -ppass --database dolphindb < 2008-05-14_09-17-38_all.sql

ERROR 1064 (42000) at line 11: 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 `AccountCompose` VALUES (1, 'My Photos', 'my_photos', '_My Photos', ' at line 14

----
Some see more files of the sql dump:

-- Database Dump For Dolphin: 6.0
--


--
-- Table structure for table `AccountCompose`
--

DROP TABLE IF EXISTS `AccountCompose`;
CREATE TABLE `AccountCompose` (
`ID` int(8) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`Div` varchar(255) NOT NULL default '',
`Caption` varchar(255) NOT NULL default '',
`Desc` varchar(255) NOT NULL default '',
`Func` varchar(40) NOT NULL default '',
`Content` text NOT NULL,
`Visible` set('non','memb') NOT NULL default '',
`Column` int(11) NOT NULL default '0',
`Order` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM
--
-- Dumping data for table `AccountCompose`
--

INSERT INTO `AccountCompose` VALUES ('1', 'My Photos', 'my_photos', '_My Photos', '', 'MyPhotos', '', '', '1', '0');
INSERT INTO `AccountCompose` VALUES ('2', 'Site Stats', 'member_stat', '_Site Stats', '', 'MembersStats', '', '', '1', '1');
INSERT INTO `AccountCompose` VALUES ('3', 'Member Info', 'member_info', '_member info', '', 'MemberInfo', '', '', '2', '0');
INSERT INTO `AccountCompose` VALUES ('4', 'Contacts', 'contacts', '_contacts', '', 'Contacts', '', '', '2', '1');
------

Please advice my site is down, thank you
josesan311
forgot to say, i was using mysql4 and then i upgraded to last mysql and im still getting the same error.

Thank you in advance.
josesan311
Looks like if i manually copy the first lines on mysql it does not show any error. This is pretty odd.

Does anyone experienced this?

mysql> INSERT INTO `AccountCompose` VALUES ('1', 'My Photos', 'my_photos', '_My Photos', '', 'MyPhotos', '', '', '1', '0');
Query OK, 1 row affected (0.00 sec)
josesan311
I simply added a ";" on every line after ) TYPE=MyISAM
and it works now.

Thanks.
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.051789999008179