Database naming error

Show current, spent, and total points based on a points base system found at
www.knights-who-say-ni.com/NKS.

Moderator: Tennessee

Database naming error

Postby bahadur » Thu Aug 14, 2008 9:06 pm

Hi thanks for the nice addon, but my roster db is named non-default. It has created the correct db tables, but when I try to upload its giving errors about the default named tables not existing.

This is the error
Code: Select all
Database Error
1146
Table 'zebra.roster_addons_karmahistory_karma' doesn't exist
SQL:
SELECT member_id FROM `roster_addons_karmahistory_karma` WHERE `fullname` = '
ananu' And `guild_id` = '1
File
libdbalmysql.php
Line
234


these are the created db tables
Code: Select all
graddons_karmahistory_karma
graddons_karmahistory_karmaitems
graddons_karmahistory_karmalog


Please let me know where if any changes I should be doing. I un/installed the addon twice and the outcome did not change.
Last edited by bahadur on Thu Aug 14, 2008 9:08 pm, edited 1 time in total.
bahadur
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Wed Jul 26, 2006 3:42 pm

Re: Database naming error

Postby Tennessee » Thu Aug 14, 2008 10:45 pm

ahh i think i know where it may be. ill post a fix
User avatar
Tennessee
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 54
Joined: Fri Apr 04, 2008 2:00 am

Re: Database naming error

Postby Tennessee » Fri Aug 15, 2008 3:20 am

Fix'ed i hope. i put up a file in the dl to fix the upload.
DL updatekarmafix.zip to fix this prob...
User avatar
Tennessee
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 54
Joined: Fri Apr 04, 2008 2:00 am

Database naming error

Postby bahadur » Fri Aug 15, 2008 4:56 am

Thanks Tennessee,

so far it seems to have worked.
bahadur
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Wed Jul 26, 2006 3:42 pm

Database naming error

Postby zanix » Fri Aug 15, 2008 6:27 am

Remember, to get the correct table name
Use this
http://www.wowroster.net/MediaWiki/Rost ... view#table

$roster->db->table('tablename','addonname')
tablename = name of the table without the prefix (ie 'roster_')
addonname = optional, base name of the addon for the table name
don't use this parameter if you are referring to a Roster core 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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to Karma History

Who is online

Users browsing this forum: No registered users and 0 guests

cron