Dramatis Personae

Supporting immersive roleplay since 2003!
See Who's In Game Right Now!
It is currently Thu May 25, 2017 5:57 pm

WARNING: Forums have been upgraded, please delete any old DP cookies from your browser, otherwise you may not be able to login correctly.

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 54 posts ]  Go to page Previous  1, 2, 3, 4  Next
Author Message
PostPosted: Thu Jan 20, 2011 10:25 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:45 pm
Posts: 4533
Location: San Diego
I saw Lady D on Earthen Ring so I went to play with her.

I logged into Hendell, gave some notes and, noticed it showed Faldeas even though I selected Hendell. I toggled my choice to Hendell and hit enter. This is the message I got and was unable to log in to view the CS afterwarrds.

I believe it added me as the message said, "There are currently two actors on stage." But I could see nothing else but this message.

#0 query_db(2, SELECT faction FROM race WHERE id = , 93, C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php) called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php:93] #1 getRaceFaction() called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\tools.class.php:1333] #2 Tools->printWhoPlaying(default, 9, ) called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\index.php:854]
Fatal error: error 93 C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php: 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
SELECT faction FROM race WHERE id = in C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php on line 36

_________________
DP Lord of Typos

"Certainly there is no hunting like the hunting of man, and those who have hunted armed men long enough and liked it, never really care for anything else thereafter" - Ernest Hemingway


Top
 Profile  
 
PostPosted: Thu Jan 20, 2011 10:35 pm 
Offline
Extra
User avatar

Joined: Sun Feb 29, 2004 8:45 pm
Posts: 1280
Location: Rocklin, CA
I believe i got the same error but I had just logged in to the call sheet. hadn't chosen a character yet. Error as follows.

#0 query_db(2, SELECT faction FROM race WHERE id = , 93, C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php) called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php:93] #1 getRaceFaction() called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\tools.class.php:1333] #2 Tools->printWhoPlaying(default, 31, ) called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\index.php:854]
Fatal error: error 93 C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php: 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
SELECT faction FROM race WHERE id = in C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php on line 36

_________________
When all is said and done, and after the dust has settled, will anyone remember we were there?

Master of Call Fu, 4th generation Tech


Top
 Profile  
 
PostPosted: Fri Jan 21, 2011 1:09 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
Yeah, Wolf, I noticed you managed to log into the Call Sheet without a character. Not sure how it did that.

Had no time in the evenings all week to do any coding. Hope to take a look at this tonight.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
PostPosted: Sun Jan 23, 2011 6:28 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
You did it again, Wolf, but I'll be danged if I know how. Where are you logging in from?

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
PostPosted: Sun Jan 23, 2011 9:03 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:45 pm
Posts: 4533
Location: San Diego
I saw, I did not want to double report, and I was in a hurry to do 2 quests and leave. I only got 1 done.

I have been logging in from my same Call Sheet Favs link. Right now I will try from the Message Boards link, which is where I saved the Favs link from.

The error you saw was the same as the first. I click Play to log in on Hendell, Earthen Ring, and while typing my notes I see it shows me logging in on Faldeas on Earthen Ring. When I toggle over to switch it back to Hendell via the drop down menu, I do get some message saying, "If you log in from here your progress could be lost." Or something to that effect.

Trying now.

_________________
DP Lord of Typos

"Certainly there is no hunting like the hunting of man, and those who have hunted armed men long enough and liked it, never really care for anything else thereafter" - Ernest Hemingway


Top
 Profile  
 
PostPosted: Sun Jan 23, 2011 9:05 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:45 pm
Posts: 4533
Location: San Diego
This time I used the link via the MB and simply clicked Quickplay vs adding notes. All worked smooth. Next time I will try the same link and click Play.

_________________
DP Lord of Typos

"Certainly there is no hunting like the hunting of man, and those who have hunted armed men long enough and liked it, never really care for anything else thereafter" - Ernest Hemingway


Top
 Profile  
 
PostPosted: Mon Jan 24, 2011 10:54 am 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
Sent you a PM. We'll get this figured out.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
PostPosted: Mon Jan 24, 2011 11:01 am 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
Everyone: If you experience a bug, here's my preferred format for reporting it. List the steps you took to get there, a page at a time. So it should look like this:

1. posting.php?mode=reply&f=23&t=7272 Open new tab to Call Sheet with link from message board heading.
2. http://callsheet.dramatis-personae.com/ Selected Selainth (FM) from drop down menu on front page, clicked "Play" button
3. http://callsheet.dramatis-personae.com/ ... layoptions Entered note "Hey this is just a test!" and left location to previous "Tirisfal Glades" and clicked "Play!" button
4. http://callsheet.dramatis-personae.com/ ... ay_id=1718 Arrive back at front page, no errors, Selainth is logged in.

Note each link is the page that you started each step on. Then each step describes what action you took (which selections you made and buttons or links you clicked, be very specific), and how you left the page. In your case, since you'll be reporting a bug, the last step will look more like:

4. http://callsheet.dramatis-personae.com/ ... ay_id=1718 Arrive back at front page, says 2 characters are onstage but only one appears in the table. It looks like it is trying to display a second character, but it breaks down into the error message below. No footer (if you don't see "Copyright 2006 Dramatis Personae || Version 1.5", the footer is missing, which means the page is cutting off).

Quote:
#0 query_db(2, SELECT faction FROM race WHERE id = , 93, C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php) called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php:93] #1 getRaceFaction() called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\tools.class.php:1333] #2 Tools->printWhoPlaying(default, 9, ) called at [C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\index.php:854]
Fatal error: error 93 C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php: 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
SELECT faction FROM race WHERE id = in C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php on line 36


The error is useful, but in a lot of cases, the steps you took to get there are more important. The error tells me what happened, it doesn't tell me how.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
PostPosted: Mon Feb 07, 2011 11:40 am 
Offline
Performer
User avatar

Joined: Wed Jul 30, 2008 8:02 pm
Posts: 191
Location: Rock, MI, USA
Mm...couple of problems here. No database error messages attached. Just some random weirdness.

1. I can't edit an existing character's server.
RELEVANT URL - http://callsheet.dramatis-personae.com/ ... ew&id=3236
EXPLANATION - I tried to change my character "Drez'fon" from Argent Dawn server to Moon Guard server. It didn't take. I also tried to change his server to other things, but it didn't take any time.

2. I can't visibly select "Forsaken" as a race on characters new or old, apparently.
RELEVANT URL - http://callsheet.dramatis-personae.com/ ... ew&id=3480
EXPLANATION - In creating a character entry for "Nairami Blake", everything set perfectly fine except for her race. While the number for "Forsaken" is selected, it comes up blank on both my overview as well as her profile. This might be due to the fact the character creation/editing menus have "Forsaken" as a choice, but the character rosters still use "Undead".

Cheers!

_________________
Formerly "Doc Lithius", currently Dramatis Personae's unofficial conversation killer #1.

Current Status: The Doc is no longer in Azeroth!


Top
 Profile  
 
PostPosted: Mon Feb 07, 2011 11:56 am 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
Oh, fudge. I know what's wrong. I didn't think of that..... grrrrrrrrrrrr. I'll try to fix this tonight.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
PostPosted: Thu Feb 10, 2011 6:35 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:45 pm
Posts: 1478
Location: Scotland/Canada Limbo
The callsheet crashes out when you try to view it without first logging in...

Code:
Backtrace:

file: 35 - C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php
call: backtrace()

file: 80 - C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\index.php
call: query_db(1, "SELECT user_rank, user_timezone FROM phpbb_users WHERE user_id =...", 80, "C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\index...")

Fatal error: error 80 C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\index.php: 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
SELECT user_rank, user_timezone FROM phpbb_users WHERE user_id = in C:\Inetpub\vhosts\dramatis-personae.com\httpdocs\callsheet\functions.php on line 36


No problems if you login first.

_________________
"Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook


Top
 Profile  
 
PostPosted: Sat Feb 12, 2011 3:08 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
Joseph Collins wrote:
Mm...couple of problems here. No database error messages attached. Just some random weirdness.

1. I can't edit an existing character's server.
RELEVANT URL - http://callsheet.dramatis-personae.com/ ... ew&id=3236
EXPLANATION - I tried to change my character "Drez'fon" from Argent Dawn server to Moon Guard server. It didn't take. I also tried to change his server to other things, but it didn't take any time.

2. I can't visibly select "Forsaken" as a race on characters new or old, apparently.
RELEVANT URL - http://callsheet.dramatis-personae.com/ ... ew&id=3480
EXPLANATION - In creating a character entry for "Nairami Blake", everything set perfectly fine except for her race. While the number for "Forsaken" is selected, it comes up blank on both my overview as well as her profile. This might be due to the fact the character creation/editing menus have "Forsaken" as a choice, but the character rosters still use "Undead".

Cheers!


Fixed. I also fixed that thing where races and classes were reverting to default on edit.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 2:42 am 
Offline
Performer
User avatar

Joined: Wed Jul 30, 2008 8:02 pm
Posts: 191
Location: Rock, MI, USA
I THOUGHT you'd fixed something when I made (yet another) new character earlier today! I went to edit her and all of a sudden, everything worked exactly like it should! X3

Alanna, we don't pay you enough for this. Thank you.

_________________
Formerly "Doc Lithius", currently Dramatis Personae's unofficial conversation killer #1.

Current Status: The Doc is no longer in Azeroth!


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 10:33 am 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
It should work properly the first time. :) but thanks. I wish it weren't such slow going.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
PostPosted: Sun Mar 13, 2011 6:00 pm 
Offline
Performer
User avatar

Joined: Wed Jul 30, 2008 8:02 pm
Posts: 191
Location: Rock, MI, USA
Hey there. Again. I simply can't keep off this thread, can I? :o

So... The call sheet doesn't auto-correct for Daylight Saving Time, apparently. It's currently reading The Hounds of Gilneas as starting at 8 PM, which is an hour away. Which would be fine, if it wasn't 8 PM RIGHT NOW. XD

_________________
Formerly "Doc Lithius", currently Dramatis Personae's unofficial conversation killer #1.

Current Status: The Doc is no longer in Azeroth!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 54 posts ]  Go to page Previous  1, 2, 3, 4  Next

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users


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® Forum Software © phpBB Group