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 10 months, 1 week 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: 10 months, 1 week ago by mrsiesta.

Re: SQL Error upon installation 10 months, 1 week ago #4663

  • dryabov
  • OFFLINE
  • Administrator
  • Lead Developer
  • Posts: 2020
  • Karma: 53
4.0.18 seems an old release. Why you don't update to 4.1.22 or 5.x?

Re: SQL Error upon installation 10 months, 1 week 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.31 seconds