[FIX UPDATE V1.2] Older mySQL compatibility.

Logs changes to the guild member list when the guild list is updated
Integrated into WoWRoster v1.7.1 and later

[FIX UPDATE V1.2] Older mySQL compatibility.

Postby Elethil » Sat Jul 29, 2006 2:02 am

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
Last edited by Elethil on Sat Jul 29, 2006 2:20 am, edited 1 time in total.
User avatar
Elethil
WR.net Journeyman
WR.net Journeyman
 
Posts: 147
Joined: Wed Jul 05, 2006 10:28 pm

Re: Member log problem

Postby Averen » Sat Jul 29, 2006 2:19 am

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.
User avatar
Averen
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 152
Joined: Thu Jul 20, 2006 5:18 am

[FIX UPDATE V1.2] Older mySQL compatibility.

Postby Fellon » Sun Jul 30, 2006 3:17 am

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.
Fellon
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Tue Jul 04, 2006 10:07 pm

[FIX UPDATE V1.2] Older mySQL compatibility.

Postby zanix » Sun Jul 30, 2006 3:21 am

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;
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

[FIX UPDATE V1.2] Older mySQL compatibility.

Postby Fellon » Sun Jul 30, 2006 3:21 am

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?
Fellon
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Tue Jul 04, 2006 10:07 pm

[FIX UPDATE V1.2] Older mySQL compatibility.

Postby zanix » Sun Jul 30, 2006 3:24 am

They probably come from his export of the table
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to Member Log

Who is online

Users browsing this forum: No registered users and 0 guests

cron