Siggen 2 bug...

A signature and avatar generator addon

Moderator: zanix

Siggen 2 bug...

Postby Averen » Sat Jan 06, 2007 7:44 am

When trying to preview an image the image is an error that reads:

Code: Select all
Error!
Line: DB
Could not get Members Data
MySQL said: 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 '' at line 1


This is from a clean install.
User avatar
Averen
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 152
Joined: Thu Jul 20, 2006 5:18 am

Siggen 2 bug...

Postby Averen » Sat Jan 06, 2007 7:59 am

Nevermind, seemed some of the files I had got corrupted, fixed now.
Last edited by Averen on Sat Jan 06, 2007 8:08 am, edited 1 time in total.
User avatar
Averen
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 152
Joined: Thu Jul 20, 2006 5:18 am

Siggen 2 bug...

Postby Jhaeldril » Sun Jan 07, 2007 12:25 am

What files were those? And how did you fix them?

I'm having the same issue. I've dumped the siggen folder as well as the database. The CHMOD settings are correct as well, triple checked.
ImageImageImage
Jhaeldril
WR.net Apprentice
WR.net Apprentice
 
Posts: 32
Joined: Thu Jul 06, 2006 4:03 am

Siggen 2 bug...

Postby zanix » Sun Jan 07, 2007 1:05 am

Try re-uploading the files to your server
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

Re: Siggen 2 bug...

Postby Jhaeldril » Sun Jan 07, 2007 9:02 pm

zanix wrote:Try re-uploading the files to your server


Done. Still no dice. I deleted the siggen directory and database and did another fresh install still no dice. Any other suggestions?
ImageImageImage
Jhaeldril
WR.net Apprentice
WR.net Apprentice
 
Posts: 32
Joined: Thu Jul 06, 2006 4:03 am

Siggen 2 bug...

Postby Mithan » Sun Jan 07, 2007 11:55 pm

I thought Siggen 2 wasn't out yet... it isn't in the download section.
Mithan
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Wed Jul 05, 2006 7:58 am

Siggen 2 bug...

Postby Jhaeldril » Mon Jan 08, 2007 1:02 am

It's actually v0.2.0

Check it out here.
ImageImageImage
Jhaeldril
WR.net Apprentice
WR.net Apprentice
 
Posts: 32
Joined: Thu Jul 06, 2006 4:03 am

Siggen 2 bug...

Postby zanix » Mon Jan 08, 2007 1:19 am

This is the section that this error would occur in

siggen.php
Code: Select all
   // Read member list from Database
   $members_str = 'SELECT * FROM `'.ROSTER_MEMBERSTABLE."` WHERE `name` LIKE '$char_name' AND `guild_id` = ".$guild_info['guild_id'].";";
   $members_sql = $wowdb->query($members_str);
   if( $members_sql )
   {
      $membersData = $wowdb->fetch_array($members_sql);
      $member_id = $membersData['member_id'];      // Gets the character ID number from the database
   }
   else
   {
      debugMode('DB','Could not get Members Data','',0,"MySQL said: ".$wowdb->error());
   }

Also, SigGen v0.2.0 is only compatible with Roster 1.7.2
It will not work with Roster 1.7.1 or 1.7.0

I may be able to make it compatible with 1.7.1, but not 1.7.0
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

Siggen 2 bug...

Postby Averen » Tue Jan 09, 2007 3:04 am

I just re-uploaded the roster 1.7.2 files, seems something went wrong with those and it wasn't passing the guild info
User avatar
Averen
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 152
Joined: Thu Jul 20, 2006 5:18 am

Siggen 2 bug...

Postby Joddie » Tue Jan 09, 2007 4:02 am

Just downloaded and tried Siggen myself now. Get the exact same message, going to try re-uploading files now.

Confirmed: This bug disapears when re-uploading the Core roster files. Would be nice to know where this bug comes from :S A well, siggen is working yet again. Thank you for developing this.
Last edited by Joddie on Tue Jan 09, 2007 4:08 am, edited 1 time in total.
Joddie
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Mon Aug 28, 2006 10:05 pm

Siggen 2 bug...

Postby Ohlo » Sat Jan 20, 2007 9:07 am

I'm getting the same error message, I've deleted the addon directory and re-uploaded but I get the same error message
Image
User avatar
Ohlo
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Tue Nov 28, 2006 8:59 am
Location: Knoxville, TN

Siggen 2 bug...

Postby zanix » Sat Jan 20, 2007 4:26 pm

Joddie and Ohlo
I need links to see this myself
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

Siggen 2 bug...

Postby Ohlo » Sun Jan 21, 2007 6:56 am

Image

and

Image

need more?
Last edited by Ohlo on Sun Jan 21, 2007 7:01 am, edited 1 time in total.
Image
User avatar
Ohlo
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Tue Nov 28, 2006 8:59 am
Location: Knoxville, TN

Siggen 2 bug...

Postby zanix » Sun Jan 21, 2007 9:09 am

A link to your roster would be nice as well

I need to see if there may be something up in Roster itself
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

Siggen 2 bug...

Postby Ohlo » Sun Jan 21, 2007 8:47 pm

Image
User avatar
Ohlo
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Tue Nov 28, 2006 8:59 am
Location: Knoxville, TN

Next

Return to SigGen

Who is online

Users browsing this forum: No registered users and 0 guests

cron