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.

Nevermind, seemed some of the files I had got corrupted, fixed now.

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.

Try re-uploading the files to your server

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?

I thought Siggen 2 wasn't out yet... it isn't in the download section.

It's actually v0.2.0

Check it out here.

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

I just re-uploaded the roster 1.7.2 files, seems something went wrong with those and it wasn't passing the guild info

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.

I'm getting the same error message, I've deleted the addon directory and re-uploaded but I get the same error message

Joddie and Ohlo
I need links to see this myself

and



need more?

A link to your roster would be nice as well

I need to see if there may be something up in Roster itself