Hello Rembrandt,
Thanks a lot for your help. Here you have the details of the error:
Bad SQL Query:
CREATE TABLE IF NOT EXISTS wwt_users_rating (
field_id int(11) unsigned NOT NULL AUTO_INCREMENT,
user_id int(11) NOT NULL DEFAULT '0',
other_user_id int(11) NOT NULL DEFAULT '0',
rating_date int(11) NOT NULL DEFAULT '0',
rating_value int(2) NOT NULL DEFAULT '0',
rating_count int(11) NOT NULL DEFAULT '0',
PRIMARY KEY(field_id)
) TYPE=MyISAM;
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' at line 9
My website ( worldwidetourist.net ) is hosted at godaddy.com. One month ago they announced an upgrade of the MySQL version, I think this could be the reason of the error.
Over the next 90 days, we're upgrading your account's database from MySQL 4.0 to MySQL 5.5. This mandatory upgrade will increase both the security and performance of your database. However, because we cannot test every possible website configuration, we wanted to notify you because the upgrade could potentially impact your site if the application using the database is out-of-date and/or incompatible with the newer version of MySQL.
Is the new version incompatible with 4images scripting mode ? Please advice what to do.
* Later Edit: I've also checked in phpmyadmin the database and for all tables were changed (from TYPE=MyISAM to ENGINE=MyISAM for the new version) but I can't realize where that query comes from as this is what I have in the sql:
DROP TABLE IF EXISTS `wwt_users_rating`;
CREATE TABLE `wwt_users_rating` (
`field_id` int(11) unsigned NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`other_user_id` int(11) NOT NULL default '0',
`rating_date` int(11) NOT NULL default '0',
`rating_value` int(2) NOT NULL default '0',
`rating_count` int(11) NOT NULL default '0',
PRIMARY KEY (`field_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `wwt_users_rating`
--
/*!40000 ALTER TABLE `wwt_users_rating` DISABLE KEYS */;
LOCK TABLES `wwt_users_rating` WRITE;
INSERT INTO `wwt_users_rating` VALUES (1,1,20,1218347182,9,1),(2,1,24,1218353047,9,1),(3,1,22,1218358665,10,1),(4,1,8,1218360020,9,1),(5,1,9,1218360040,9,1),(6,1,48,1223750565,8,1),(7,1,51,1224318273,10,1),(8,48,51,1224322328,10,1),(9,161,51,1238486555,10,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `wwt_users_rating` ENABLE KEYS */;
Thanks
D.R.