Am I missing something? I downloaded the full version with moded files. I uploaded all the files where they should be as far as I can see. I get the following when I try to access the members log in the roster.

064: 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 latin1_general_ci NOT NULL default '', `type`
SQL:
CREATE TABLE `roster_addon_memberlog` ( `id` int(10) NOT NULL auto_increment, `name` varchar(30) collate latin1_general_ci NOT NULL default '', `type` enum('OLD','NEW') collate latin1_general_ci NOT NULL default 'OLD', `date` int(15) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
File: install_db.php
Line: 21

Ok, the mySQL code wasn't backwards compatible. Use

Code: Select all

CREATE TABLE `roster_addon_memberlog` (
 `id` int(10) NOT NULL auto_increment,
 `name` varchar(30) collate latin1_general_ci NOT NULL default '',
 `type` enum('OLD','NEW') collate latin1_general_ci NOT NULL default 'OLD',
 `date` int(15) NOT NULL default '0',
 PRIMARY KEY  (`id`)
) TYPE=MyISAM;


Or download the update from here.

Still having issues when I try to run the sql string for the database.

Code: Select all

#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 'collate latin1_general_ci NOT NULL default '',
`type` enum('O


This is the error I get from phpMyAdmin when I manualy try to insert the string.

Remove all the "collate latin1_general_ci" parts

Edit code

Code: Select all

CREATE TABLE `roster_addon_memberlog` (
 `id` int(10) NOT NULL auto_increment,
 `name` varchar(30) NOT NULL default '',
 `type` enum('OLD','NEW') NOT NULL default 'OLD',
 `date` int(15) NOT NULL default '0',
 PRIMARY KEY  (`id`)
) TYPE=MyISAM;

Okay. Got it working.
I had to drop the collate commands.

Code: Select all

CREATE TABLE `roster_addon_memberlog` (
 `id` int(10) NOT NULL auto_increment,
 `name` varchar(30) NOT NULL default '',
 `type` enum('OLD','NEW') NOT NULL default 'OLD',
 `date` int(15) NOT NULL default '0',
 PRIMARY KEY  (`id`)
) TYPE=MyISAM;


Is there any reason those "must" be included? So I can be prepared for any rather fun bugs I might have spun off from the removals?

They probably come from his export of the table