Install mysql error - 2007/04/17 02:12
Tried installing and get the following error with the component ...
Code:
SQL Error DB function failed with error number 1064
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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 7 SQL=CREATE TABLE `jos_th_user_read` ( `id` int(11) NOT NULL auto_increment, `item_id` int(11) default NULL, `user_id` int(11) default NULL, `created` date default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
SQL =
CREATE TABLE `jos_th_user_read` (
`id` int(11) NOT NULL auto_increment,
`item_id` int(11) default NULL,
`user_id` int(11) default NULL,
`created` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Any ideas?
The administrator has disabled public write access.
dwsmgr
Fresh Boarder
Re:Install mysql error - 2007/04/17 10:09
I have had the same experience on a server with the following configuration:
PHP built On: Linux Database Version: 3.23.58 PHP Version: 4.3.10 Web Server: Apache/2.0.51 (Fedora) Joomla! Version: Joomla! 1.0.12 Stable
Joomla! Register Globals Emulation: OFF Register Globals: OFF Magic Quotes:OFF Safe Mode: OFF File Uploads:ON Session auto start:OFF
Any suggestions?
The administrator has disabled public write access.
yerg
Fresh Boarder
Re:Install mysql error - 2007/04/20 01:01
I'm pretty much the same
PHP built On: Linux 2.4.21-40.EL #1 Wed Mar Database Version: 4.0.27-standard PHP Version: 4.4.4 Web Server: Apache Joomla! Version: Joomla! 1.0.12 Stable
Joomla! Register Globals Emulation: OFF Register Globals: OFF Magic Quotes: ON Safe Mode: OFF File Uploads: ON Session auto start: OFF
The administrator has disabled public write access.
PlayGod
Fresh Boarder
Re:Install mysql error - 2007/04/28 03:45
This is a bit complicated to fix, but it's a relatively simple problem.
First, you'll need to clean up your failed installs: DROP all of the _th_ tables from your db, and delete the com_thopper folder from your Joomla components folder.
Next, you'll need to extract the com_thopper.zip and edit thopper.xml. Open it and delete "DEFAULT CHARSET=latin1" from the query that caused the error. If you see it anywhere else in the SQL queries, delete it, because it'll cause more trouble on your next attempted install.
Save thopper.xml and re-archive the extracted files and folders into a new com_thopper.zip.
Now, you should be able to have a successful install.
The administrator has disabled public write access.
kase
Admin
Re:Install mysql error - 2007/05/17 09:26
The current version of TH requires your DB to be at least 4.1.x We did this for security reasons when we released TH 1.1. We state this in our download screen and it's mentioned here I think. Very sorry about this. I'll make the download message larger/bolder.
Post edited by: kase, at: 2007/05/17 12:38
The administrator has disabled public write access.
PlayGod
Fresh Boarder
Re:Install mysql error - 2007/05/28 16:12
nonetheless, TH will function on mySQL 4.0.27+, using the above info... probably not recommended for a production system.
I have had to migrate several db's from broken/hacked/unstable database servers running 4.1 to a server running 4.0.27, and it's possible to clean up an SQL dump or query to make it backward compatible. Again, this is obviously not recommended for security reasons, but if you must do it, you must do it.
The administrator has disabled public write access.
I'll make the download message larger/bolder.
