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
 
 
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.03960394859314