[svn 1500] Main/alt update relations button

by **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?

by **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.

by **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

by **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

by **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

by **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?

by **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.