Welcome, Guest
Username Password: Remember me

SQL Error upon installation
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: SQL Error upon installation

SQL Error upon installation 13 years, 4 months ago #4661

  • mrsiesta
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
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)
Last Edit: 13 years, 4 months ago by mrsiesta.

Re: SQL Error upon installation 13 years, 4 months ago #4663

  • dryabov
  • OFFLINE
  • Administrator
  • Denis Ryabov, Lead Developer
  • Posts: 4867
  • Karma: 105
4.0.18 seems an old release. Why you don't update to 4.1.22 or 5.x?

Re: SQL Error upon installation 13 years, 4 months ago #4682

  • mrsiesta
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Probably because, it is almost impossible to migrate 4.0 to 5.x
  • Page:
  • 1
Time to create page: 0.06 seconds

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.