[svn 1500] Main/alt update relations button

Posts from previous Beta sessions

[svn 1500] Main/alt update relations button

Postby benv666 » Sun Dec 09, 2007 8:37 pm

After reading the thread about the unicode in names, I figured to update the regexp to use \pL instead of \w.
So I did.

However, when I hit the "Update Relations" button, I got this lovely error:
Code: Select all
064: 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
SQL:
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = ;

Obviously the guild_id is missing. But is seems to be present in the URL:
http://roster2.handofhades.eu/index.php ... date&a=g:1

Any idea? :)
benv666
WR.net Apprentice
WR.net Apprentice
 
Posts: 42
Joined: Wed May 09, 2007 5:04 pm
Location: The Netherlands

[svn 1500] Main/alt update relations button

Postby PleegWat » Mon Dec 10, 2007 5:08 pm

I'm not seeing this in the latest build, and the code here hasn't changed since your build.

Can you paste the full error please (As in, the trace?). You may have to use a text attachment.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Re: [svn 1500] Main/alt update relations button

Postby benv666 » Mon Dec 10, 2007 5:24 pm

Since there were some more errors below I figured I'd give you the entire HTML.
Attached gzipped. If you need more please let me know :)
Attachments
wowroster [ hand of hades @ eu-frostwhisper ] database error.html.gz
(17.81 KiB) Downloaded 68 times
benv666
WR.net Apprentice
WR.net Apprentice
 
Posts: 42
Joined: Wed May 09, 2007 5:04 pm
Location: The Netherlands

[svn 1500] Main/alt update relations button

Postby Naesstrom » Tue Dec 11, 2007 1:36 am

well I have the same thing, just updated to 1500 and was trying to get the alt/main relations going again and it hit me with:

Code: Select all
064: 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
SQL:
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = ;
File: lib/dbal/mysql.php
Line: 207
Backtrace (most recent call last):

    * lib/functions.lib.php
          o Line: 240
          o Function Called: backtrace
    * lib/dbal/mysql.php
          o Line: 207
          o Function Called: die_quietly
          o Arguments:
                + 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
                + Database Error
                + /customers/naesstrom.net/naesstrom.net/httpd.www/guild/roster/lib/dbal/mysql.php
                + 207
                + SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = ;
    * addons/memberslist/inc/update_hook.php
          o Line: 95
          o Function Called: query
          o Arguments:
                + SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = ;
    * addons/memberslist/admin/update.php
          o Line: 59
          o Function Called: guild_pre
          o Arguments:
                + Array ( [Members] => Array ( [Nissedisse] => Array ( [0] => 0 [guild_id] => 0 [1] => 2 [member_id] => 2 [2] => Nissedisse [Name] => Nissedisse [3] => [Note] => [4] => [OfficerNote] => ) [Rosia] => Array ( [0] => 0 [guild_id] => 0 [1] => 3 [member_id] => 3 [2] => Rosia [Name] => Rosia [3] => [Note] => [4] => [OfficerNote] => ) [Cobalta] => Array ( [0] => 0 [guild_id] => 0 [1] => 4 [member_id] => 4 [2] => Cobalta [Name] => Cobalta [3] => [Note] => [4] => [OfficerNote] => ) [Aurora] => Array ( [0] => 0 [guild_id] => 0 [1] => 8 [member_id] => 8 [2] => Aurora [Name] => Aurora [3] => [Note] => [4] => [OfficerNote] => ) [Donato] => Array ( [0] => 0 [guild_id] => 0 [1] => 13 [member_id] => 13 [2] => Donato [Name] => Donato [3] => [Note] => [4] => [OfficerNote] => ) [Lirith] => Array ( [0] => 0 [guild_id] => 0 [1] => 16 [member_id] => 16 [2] => Lirith [Name] => Lirith [3] => [Note] => [4] => [OfficerNote] => ) [Neez] => Array ( [0] => 0 [guild_id] => 0 [1] => 18 [member_id] => 18 [2] => Neez [Name] => Neez [3] => [Note] => [4] => [OfficerNote] => ) [Annai] => Array ( [0] => 0 [guild_id] => 0 [1] => 33 [member_id] => 33 [2] => Annai [Name] => Annai [3] => [Note] => [4] => [OfficerNote] => ) [Alunara] => Array ( [0] => 0 [guild_id] => 0 [1] => 34 [member_id] => 34 [2] => Alunara [Name] => Alunara [3] => [Note] => [4] => [OfficerNote] => ) [Lunos] => Array ( [0] => 0 [guild_id] => 0 [1] => 35 [member_id] => 35 [2] => Lunos [Name] => Lunos [3] => [Note] => [4] => [OfficerNote] => ) [Starrain] => Array ( [0] => 0 [guild_id] => 0 [1] => 42 [member_id] => 42 [2] => Starrain [Name] => Starrain [3] => [Note] => [4] => [OfficerNote] => ) [Skunkyfunky] => Array ( [0] => 0 [guild_id] => 0 [1] => 51 [member_id] => 51 [2] => Skunkyfunky [Name] => Skunkyfunky [3] => [Note] => [4] => [OfficerNote] => ) [Nezarios] => Array ( [0] => 0 [guild_id] => 0 [1] => 59 [member_id] => 59 [2] => Nezarios [Name] => Nezarios [3] => [Note] => [4] => [OfficerNote] => ) [Lilja] => Array ( [0] => 0 [guild_id] => 0 [1] => 62 [member_id] => 62 [2] => Lilja [Name] => Lilja [3] => [Note] => [4] => [OfficerNote] => ) [Mithal] => Array ( [0] => 0 [guild_id] => 0 [1] => 66 [member_id] => 66 [2] => Mithal [Name] => Mithal [3] => [Note] => [4] => [OfficerNote] => ) [Woden] => Array ( [0] => 0 [guild_id] => 0 [1] => 67 [member_id] => 67 [2] => Woden [Name] => Woden [3] => [Note] => [4] => [OfficerNote] => ) [Gripper] => Array ( [0] => 0 [guild_id] => 0 [1] => 68 [member_id] => 68 [2] => Gripper [Name] => Gripper [3] => [Note] => [4] => [OfficerNote] => ) [Rosacat] => Array ( [0] => 0 [guild_id] => 0 [1] => 69 [member_id] => 69 [2] => Rosacat [Name] => Rosacat [3] => [Note] => [4] => [OfficerNote] => ) [Anirai] => Array ( [0] => 0 [guild_id] => 0 [1] => 71 [member_id] => 71 [2] => Anirai [Name] => Anirai [3] => [Note] => [4] => [OfficerNote] => ) [Sauriel] => Array ( [0] => 0 [guild_id] => 0 [1] => 72 [member_id] => 72 [2] => Sauriel [Name] => Sauriel [3] => [Note] => [4] => [OfficerNote] => ) [Wolgar] => Array ( [0] => 0 [guild_id] => 0 [1] => 88 [member_id] => 88 [2] => Wolgar [Name] => Wolgar [3] => [Note] => [4] => [OfficerNote] => ) ) )
    * admin/addon_conf.php
          o Line: 62
          o Function Called: include_once
          o Arguments:
                + /customers/naesstrom.net/naesstrom.net/httpd.www/guild/roster/addons/memberslist/admin/update.php
    * pages/rostercp.php
          o Line: 116
          o Function Called: require_once
          o Arguments:
                + /customers/naesstrom.net/naesstrom.net/httpd.www/guild/roster/admin/addon_conf.php
    * index.php
          o Line: 83
          o Function Called: require
          o Arguments:
                + /customers/naesstrom.net/naesstrom.net/httpd.www/guild/roster/pages/rostercp.php
Naesstrom
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Sun Aug 27, 2006 4:09 pm

[svn 1500] Main/alt update relations button

Postby PleegWat » Tue Dec 11, 2007 1:47 am

Ah, damn, course. The bugged guild_id=0 members. In a fresh install, those don't exist anymore.

Should be fixed in 1517
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

[svn 1500] Main/alt update relations button

Postby mfoley » Sat Jan 26, 2008 11:46 pm

What's the fix? Searching on this table in the forums only came up with one hit. Is there another post discussing this?
User avatar
mfoley
WR.net Apprentice
WR.net Apprentice
 
Posts: 55
Joined: Tue Aug 08, 2006 11:27 am

[svn 1500] Main/alt update relations button

Postby PleegWat » Sun Jan 27, 2008 8:07 pm

The fix was applied in SVN 1517. If you're running a version that old, it's high time to update to a more recent build. If you're running something newer, start a new thread with a description of your actual problem.

We've got few problems with the actual backend of the main/alt system.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm


Return to Archived

Who is online

Users browsing this forum: No registered users and 0 guests

cron