Wolf Faction

General

About this site
Login
Register

Forum

All Forums
FAQ

My stuff

Out-of-Character Information

General
New Picture Gallery
Old Picture Gallery
Events
Links
 

All times are UTC



Post new topic Reply to topic  [ 36 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Online Booking problems - Feb 2010
PostPosted: Mon Feb 22, 2010 10:45 pm 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 1:24 pm
Posts: 9442
Location: North Herts / South Jotunheim
Real Name: Dave Miller
I'm told there are problems but I can't reproduce them.
If you're having problems please leave the details here.

As important as any error message is detailing what point in the booking procees you are/were at.
The page name isn't enought as the same page can do different things at different stages.


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Tue Feb 23, 2010 12:24 pm 
Offline
Member
User avatar

Joined: Wed Jun 02, 2004 9:30 pm
Posts: 1062
Location: Sluff
Real Name: Patrick OBrien
Hello,

I click on 'Events' on the side bar > 'Book Online'

and get:

Code:
General Error
SQL ERROR [ mysql4 ]

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 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: webadmin@wolf-faction.com


Hope that helps :)

_________________
Niall O'Farrel

Storm Raven, The Caribou, Cosmopolitan Creature of Chaos, Most Fixed Human, nearly Chaos Oath Sworn.


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Tue Feb 23, 2010 6:27 pm 
Offline
Member

Joined: Thu Feb 18, 2010 9:14 pm
Posts: 1
Real Name: shaun
Am getting the same here.


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Tue Feb 23, 2010 7:56 pm 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 1:24 pm
Posts: 9442
Location: North Herts / South Jotunheim
Real Name: Dave Miller
Hmmmmmmmmmmmmmmmmmmmmmmmmmmm........


Try going there via http://event.wolf-faction.com/ and see what happens?


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Tue Feb 23, 2010 8:32 pm 
Offline
Member
User avatar

Joined: Wed Jun 02, 2004 9:30 pm
Posts: 1062
Location: Sluff
Real Name: Patrick OBrien
No difference I'm afraid.

_________________
Niall O'Farrel

Storm Raven, The Caribou, Cosmopolitan Creature of Chaos, Most Fixed Human, nearly Chaos Oath Sworn.


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Tue Feb 23, 2010 9:27 pm 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 1:24 pm
Posts: 9442
Location: North Herts / South Jotunheim
Real Name: Dave Miller
Hmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm

Operating system(s) and browser(s) ?


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Tue Feb 23, 2010 9:46 pm 
Offline
Member
User avatar

Joined: Wed Jun 02, 2004 9:30 pm
Posts: 1062
Location: Sluff
Real Name: Patrick OBrien
Home PC: brand new HP running Windows 7, IE 8, Google Chrome.

Work PC: ye olde PC running XP and IE 8.

_________________
Niall O'Farrel

Storm Raven, The Caribou, Cosmopolitan Creature of Chaos, Most Fixed Human, nearly Chaos Oath Sworn.


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Wed Feb 24, 2010 1:26 pm 
Offline
Member
User avatar

Joined: Wed Jun 02, 2004 9:30 pm
Posts: 1062
Location: Sluff
Real Name: Patrick OBrien
Just an update, I've posted off my forms etc. Didn't want to miss any deadlines. Strange problem though...

_________________
Niall O'Farrel

Storm Raven, The Caribou, Cosmopolitan Creature of Chaos, Most Fixed Human, nearly Chaos Oath Sworn.


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Wed Feb 24, 2010 1:36 pm 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 1:24 pm
Posts: 9442
Location: North Herts / South Jotunheim
Real Name: Dave Miller
Strange indeed, that many can do it and a just some can't.
I hate that!


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Wed Feb 24, 2010 2:27 pm 
Offline
Member
User avatar

Joined: Wed Jun 02, 2004 9:30 pm
Posts: 1062
Location: Sluff
Real Name: Patrick OBrien
Could be something to do with the user accounts.

_________________
Niall O'Farrel

Storm Raven, The Caribou, Cosmopolitan Creature of Chaos, Most Fixed Human, nearly Chaos Oath Sworn.


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 9:40 am 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 11:15 am
Posts: 2050
Location: Birmingham, UK
Real Name: Rich Gaunt
Don't know whether it helps, but I can access those pages fine. Firefox on Vista.


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 11:01 am 
Offline
Member

Joined: Mon Feb 23, 2004 3:43 pm
Posts: 2602
Real Name: Malc
Lots of other people are booking fine with the system so tracking down the issue may be quite difficult.

_________________
You can take the man out of Norsca but you can't stop him beating the **** out of anything that annoys him.


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 12:39 pm 
Offline
Member
User avatar

Joined: Sun Mar 13, 2005 12:49 pm
Posts: 1858
Location: Woking
Real Name: Mark Phelan
If I recall correctly, I had a similar poroblem aeons ago... and it was something to do with my profile havign been created before the booking system changed.

_________________
En la mallumo de la nokto, nur la forta estas sentimaj, la malforta kurantoj en timo kaj mortas sole.
Marshal 174, Bow and Claw Comp Tester, Weapon Checker.
Mark Phelan


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 1:18 pm 
Offline
Member
User avatar

Joined: Wed Jun 02, 2004 9:30 pm
Posts: 1062
Location: Sluff
Real Name: Patrick OBrien
My profile is old, but Shaun's (Charles Falcon) is completely new.

_________________
Niall O'Farrel

Storm Raven, The Caribou, Cosmopolitan Creature of Chaos, Most Fixed Human, nearly Chaos Oath Sworn.


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 3:45 pm 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 1:24 pm
Posts: 9442
Location: North Herts / South Jotunheim
Real Name: Dave Miller
Hmmm, Paddy, try going to to My Character and resaving the details???...


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 10:44 pm 
Offline
Member
User avatar

Joined: Wed Jun 02, 2004 9:30 pm
Posts: 1062
Location: Sluff
Real Name: Patrick OBrien
Nope still got that error.


Top
 Profile  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 10:50 pm 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 1:24 pm
Posts: 9442
Location: North Herts / South Jotunheim
Real Name: Dave Miller
I'm mostly baffled. Print a form?.....


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Thu Feb 25, 2010 11:49 pm 
Offline
Member

Joined: Mon Feb 23, 2004 3:43 pm
Posts: 2602
Real Name: Malc
I got your postal booking Paddy and its all in the system now. But to try and find the root of this issue, maybe you could use the "add name" field/button as though you were booking for someone else then fill your details in there to see if it works (or any details as I can delete them from this end anyway).

_________________
You can take the man out of Norsca but you can't stop him beating the **** out of anything that annoys him.


Top
 Profile E-mail  
 
 Post subject: Re: Online Book problems - Feb 2010
PostPosted: Fri Feb 26, 2010 1:07 pm 
Offline
Member
User avatar

Joined: Tue Feb 03, 2004 3:21 pm
Posts: 260
Location: Duffield
Real Name: Ross
After reading this post i thought i'd try to access the page to see and get ..
Quote:
General Error
SQL ERROR [ mysql4 ]

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 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


I'm running on Windows 7 and Chrome, tried it in IE8 (64) and get the same problem

and this is thrown up when i click the book online button.

I'm afraid I can't make the event just trying to help with a bit of information.


Top
 Profile  
 
 Post subject: Re: Online Booking problems - Feb 2010
PostPosted: Sat Feb 27, 2010 3:32 pm 
Offline
Site Admin
User avatar

Joined: Tue Feb 03, 2004 11:15 am
Posts: 2050
Location: Birmingham, UK
Real Name: Rich Gaunt
From the feedback, it's pretty certain that it's not platform/browser issues, so must be something odd with the data on those accounts.

It's not "age of account" as some really old accounts (like mine) are able to book fine and some newer accounts fail.

In my experience, this happens when a variable with an empty value is substituted into a query.

ie.
If the base query string looks like:
"SELECT * FROM mytable WHERE name=$myname AND othervalue=$myothervalue"

Now, if $myname had a nil value, then the resulting query string could be something like:

"SELECT * FROM mytable WHERE name= AND othervalue=2"

Which will fail and generate the message that people are seeing.

Similar can happen if $myname includes invalid characters or stuff that doesn't have the correct escape sequences for inclusion.

Hope that's some help?


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 36 posts ]  Go to page 1, 2  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group