SQL Error upon installation

mrsiesta
13 years, 9 months ago
Hi,

upon installation I get this sql error:
Database error: 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 'collate utf8_bin NOT NULL default '', `cache_data` mediumtext SQL=CREATE TABLE `jos_TeraWurflCache` ( `user_agent` varchar(255) character set utf8 collate utf8_bin NOT NULL default '', `cache_data` mediumtext NOT NULL, PRIMARY KEY (`user_agent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

on frontpage it display this error upon white screen: Error: Table 'xxxxx_xxxxxxx.jos_terawurflcache' doesn't exist

My MySql parameters:
Server version: 4.0.18-max-debug
MySQL client version: 3.23.49
Used PHP extensions: mysql
Database Collation: N/A (mySQL < 4.1.2)
PHP Version: 5.2.17
Web Server: Apache/2.2.16 (Debian)
dryabov
13 years, 9 months ago
4.0.18 seems an old release. Why you don't update to 4.1.22 or 5.x?
mrsiesta
13 years, 9 months ago
Probably because, it is almost impossible to migrate 4.0 to 5.x

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. This site will not function correctly without cookies.

I accept cookies from this site.