1146: Table 'roster2.roster_addons_pvplog_pvp2' doesn't exis

by **vblars** » Tue Oct 30, 2007 6:46 pm

I did get this error after update to WoWRoster v1.9.9.1418.

SQL:
SELECT `pvp`.`guild`, COUNT(`pvp`.`guild`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`guild` ORDER BY countg DESC
File: lib\dbal\mysql.php
Line: 203
Backtrace (most recent call last):

* lib\functions.lib.php
o Line: 240
o Function Called: backtrace
* lib\dbal\mysql.php
o Line: 203
o Function Called: die_quietly
o Arguments:
+ 1146: Table 'roster2.roster_addons_pvplog_pvp2' doesn't exist
+ Database Error
+ F:\websrv\www\r2\lib\dbal\mysql.php
+ 203
+ SELECT `pvp`.`guild`, COUNT(`pvp`.`guild`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`guild` ORDER BY countg DESC
* addons\pvplog\inc\pvplist.php
o Line: 45
o Function Called: query
o Arguments:
+ SELECT `pvp`.`guild`, COUNT(`pvp`.`guild`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`guild` ORDER BY countg DESC
* addons\memberslist\guild\index.php
o Line: 217
o Function Called: generatePvpList
* index.php
o Line: 128
o Function Called: require
o Arguments:
+ F:\websrv\www\r2\addons\memberslist\guild\index.php

My Web Page

by **PleegWat** » Tue Oct 30, 2007 7:39 pm

[quote=release notes]1415
- PvPLog now uses an addon compliant table name `roster_addons_pvplog_pvp2`
-- You can rename the `roster_pvp2` table to `roster_addons_pvplog_pvp2` and pvplog will continue working[/quote]

by **orloph** » Tue Oct 30, 2007 8:31 pm

Just beware if you changed the default prefix "roster" in something else.

Example: if your customized prefix is "NewPrefix" then the new table name will be "NewPrefix_addons_pvplog_pvp2".

Or disable the pvp addon

by **zanix** » Wed Oct 31, 2007 12:06 am

This is beta guys, pay attention to the notes for each build

by **vblars** » Wed Oct 31, 2007 4:59 am

ok thanks guys I vill.

by **vblars** » Wed Oct 31, 2007 6:07 am

I've uninstalled pvp in Manage Addons and then installed it again and now it works. Just if other got the same error then they can see what I did to correct it.

by **zanix** » Wed Oct 31, 2007 6:15 am

Didn't you read this?

-- You can rename the `roster_pvp2` table to `roster_addons_pvplog_pvp2` and pvplog will continue working

You could of just re-named that table in phpmyadmin and it would continue to work

by **vblars** » Wed Oct 31, 2007 7:37 am

Yes I did and tried the uninstall/install first because I don't have so many(none) data in pvp at the moment. So I didn't need to rename it.

by **zanix** » Wed Oct 31, 2007 7:45 am

The installer will not remove the old roster_pvp table
So you may want to remove it manually

Who is online