SQL Error

Dragonfly integration forum

SQL Error

Postby Equisetum » Fri Feb 16, 2007 5:34 pm

Hi all,

Last night I loaded the wowdb.php hotfix, and when I got up this morning I received a number of admin emails from my site with the following error.

Code: Select all
On /index.php?name=WoWRosterDF&file=addon&roster_addon_name=siggen&mode=signature&member=Nehunter&saveonly=0
While executing query "SELECT * FROM `cms_wowrosterdf_roster_addon_siggen` WHERE `config_id` LIKE 'signature';"

the following error occured: Table 'dragonfly.cms_wowrosterdf_roster_addon_siggen' doesn't exist

In: /home/httpd/vhosts/rage-and-mana.com/subdomains/wow/httpdocs/modules/WoWRosterDF/lib/wowdb.php on line: 96


I seem to have received an email with this error for almost every one who has updated so far.

Any ideas?

Thanks so much!

~Eq
User avatar
Equisetum
WR.net Apprentice
WR.net Apprentice
 
Posts: 65
Joined: Mon Jul 24, 2006 6:44 am

SQL Error

Postby Equisetum » Fri Feb 16, 2007 5:41 pm

Seemingly related, when I try to view the roster page after loading the wowdb.php, I get the following error:

Code: Select all
settings.php: line[135]
Could not connect to database "******"
MySQL said:
0:


I replaced the wowdb.php with the original file in the release and it works fine.

I'm still, however, getting the Siggen password error everyone seems to have.
User avatar
Equisetum
WR.net Apprentice
WR.net Apprentice
 
Posts: 65
Joined: Mon Jul 24, 2006 6:44 am

Re: SQL Error

Postby robojerk » Fri Feb 16, 2007 6:11 pm

Equisetum wrote:I'm still, however, getting the Siggen password error everyone seems to have.


Siggen fix
Last edited by robojerk on Fri Feb 16, 2007 6:11 pm, edited 1 time in total.
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

SQL Error

Postby robojerk » Fri Feb 16, 2007 6:14 pm

Try re downloading the wowdb.php fix, then upload it.. Maybe you got a corrupted download or something.

Also do you have Display Signature and Display Avatar turned on? Both of those require Siggen to be installed..
Last edited by robojerk on Fri Feb 16, 2007 6:16 pm, edited 1 time in total.
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

Re: SQL Error

Postby RottGutt » Sun Feb 18, 2007 8:33 pm

I have uploaded the addon hotfix, the wowdb hotfix, made sure all the folders in my /img and /sig folders are 777, commented out the lines related to passwords in the index.php, and installed siggen successfully. I am able to see previews of Avatars, but get an error when I try to preview Sigs. Nor are the Avatars and Sigs being saved to my server, although I have them set to in the Siggen config.

EDIT: On a whim I did a "reset to defaults" on both the Sigs and the Avatars. I am able to preview both of them successfully now, and they are showing up ok when I click a character in the main Roster itself. They are still not being saved to the server though, and when I do a fresh upload of CharacterProfiler.lua I get all blank image boxes where the Avs and Sigs should be.
Attachments
upload.jpg
Where are the Sigs and Avatars?
upload.jpg (31.83 KiB) Viewed 1141 times
Last edited by RottGutt on Sun Feb 18, 2007 8:56 pm, edited 5 times in total.
RottGutt
WR.net Journeyman
WR.net Journeyman
 
Posts: 92
Joined: Sun Aug 13, 2006 12:07 am

SQL Error

Postby Anaxent » Sun Feb 18, 2007 9:17 pm

ya know I bet that is because I may have forgoten to edit the trigger.php file. I will get a new version of siggen out to you all soon.
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

Re: SQL Error

Postby RottGutt » Tue Feb 20, 2007 1:59 pm

Anaxent wrote:ya know I bet that is because I may have forgoten to edit the trigger.php file. I will get a new version of siggen out to you all soon.


Sweet. I am sure I speak for everyone when I say thank you for all the work you put into this project!

RottGutt
RottGutt
WR.net Journeyman
WR.net Journeyman
 
Posts: 92
Joined: Sun Aug 13, 2006 12:07 am


Return to Dragonfly

Who is online

Users browsing this forum: No registered users and 1 guest

cron