Mysql Version???? cant install dolphin since upgrade mysql to 4.1.22
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!!!
Can you send me access details to your server via PM here at unity?
We will look and help you in resolving this.
later,
DosDawg
# 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
Thank you in advance.
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)
and it works now.
Thanks.