MembersList PHP errors

by **Splash** » Wed Sep 26, 2007 10:34 pm

Hi

Running 1355 (though I was getting this with 1337 too) when I look to the bottom of the members list I'm getting lots of

PHP Errors
addons/memberslist/inc/memberslist.php
Notice line 710: Undefined index: talent_text
Notice line 719: Undefined index: class_text
Notice line 740: Undefined index: class_text

this repeats, site is http://dev.seedsofglory.net if anyone needs to take a look.

by **PleegWat** » Wed Sep 26, 2007 11:12 pm

This probably means the memberslist config layout has been changed since the last time you installed the addon. Uninstall and reinstall it and they should go away.

by **Splash** » Wed Sep 26, 2007 11:51 pm

Uninstalled fine, on reinstall it throws

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 'member_id` int(11) unsigned NOT NULL default '0', `main_id` int(11) u' at line 2
SQL:
CREATE TABLE `roster_addons_memberslist_alts` `member_id` int(11) unsigned NOT NULL default '0', `main_id` int(11) unsigned NOT NULL default '0', `alt_type` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`member_id`) ENGINE=MyISAM DEFAULT CHARSET=utf8;
File: lib/dbal/mysql.php
Line: 203
Backtrace (most recent call last):

* lib/functions.lib.php
o Line: 236
o Function Called: backtrace
* lib/dbal/mysql.php
o Line: 203
o Function Called: die_quietly
o Arguments:
+ 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 'member_id` int(11) unsigned NOT NULL default '0', `main_id` int(11) u' at line 2
+ Database Error
+ /home/splash/public_html/dev/lib/dbal/mysql.php
+ 203
+ CREATE TABLE `roster_addons_memberslist_alts` `member_id` int(11) unsigned NOT NULL default '0', `main_id` int(11) unsigned NOT NULL default '0', `alt_type` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`member_id`) ENGINE=MyISAM DEFAULT CHARSET=utf8;
* lib/install.lib.php
o Line: 235
o Function Called: query
o Arguments:
+ CREATE TABLE `roster_addons_memberslist_alts` `member_id` int(11) unsigned NOT NULL default '0', `main_id` int(11) unsigned NOT NULL default '0', `alt_type` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`member_id`) ENGINE=MyISAM DEFAULT CHARSET=utf8;
* admin/addon_install.php
o Line: 503
o Function Called: install
* admin/addon_install.php
o Line: 46
o Function Called: processaddon
* pages/rostercp.php
o Line: 96
o Function Called: require_once
o Arguments:
+ /home/splash/public_html/dev/admin/addon_install.php
* index.php
o Line: 67
o Function Called: require
o Arguments:
+ /home/splash/public_html/dev/pages/rostercp.php

Any ideas?

by **Splash** » Wed Sep 26, 2007 11:55 pm

Site layout now appears a tad wonky - I'm tempted to go for a full reinstall with the latest build unless you'd prefer me to keep things as is for bug testing?

by ds » Thu Sep 27, 2007 12:00 am

Try this fix here: http://www.wowroster.net/Forums/viewtopic/t=4333.html

by **Splash** » Thu Sep 27, 2007 6:29 pm

Cheers - updating to 1359 fixed it, but seems to have broken ArmorySynch somewhat - will try a reinstall of the latest version of that plugin