vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Event attendance (https://vborg.vbsupport.ru/showthread.php?t=63460)

xTerMn8R 08-29-2004 10:31 PM

Thought everything was working good but tried to add an event today and the following is what I got. Any suggestions?

Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                                INSERT INTO event (calendarid, userid, event, recurring, recuroption,dateline_to,dateline_from,    title, allowsmilies, customfields, dateline, visible, utc, useroll);
                                VALUES (1, 1, 'Test', '0', '', '0', '1093737600', 'Test Event', '1', 'a:0:{}', 1093822044, 1, '0', '0');
                       
mysql error: 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 ';
                                VALUES (1, 1, 'Test', '0', '

mysql error number: 1064

Date: Sunday 29th of August 2004 07:27:25 PM
Script: http://www.byte-psyche.com/calendar.php
Referer: http://www.byte-psyche.com/calendar.php?do=add&type=single&c=1
Username: xTerMn8R
IP Address: 192.168.1.1

Thank you...

Peace

neroflorida 08-31-2004 01:52 PM

There appears to be a bug in the software that causes accumulation of data if:
A) Multiple Events Occur On Same Day, and
B) Events Use Roll Call Feature

Example data:

Event #1 -
Actual Roll Call: User1, User2, User3
Displayed Roll Call: User1, User2, User3

Event #2 -
Actual Roll Call: User4
Displayed Roll Call: User1, User2, User3, User4

...

Would appear that the array isn't cleared between cycles? Haven't had a chance to look at the code yet to verify.

y2krazy 08-31-2004 11:03 PM

Quote:

Originally Posted by Pseudomizer
Sounds like a PHP problem of the post and get parameters of a HTML form. Do you have global variables on or off? This could cause this problem.

If you do not have them enabled and for security reasons, you should let them disabled, you can replace the variables with $_POST[variablenames] or $_GET[variablenames] and it should work.

Cheers,

Would be great if someone could clarify what Pseudo meant for me to do. I really would like to get this working, preferrably within the next 2 weeks! Thanks! :cry:

Original post:
Quote:

Originally Posted by y2krazy
For every event in my calendar, when I click on [I will be attending this event.], it send me to a forum error message that states the following:

"Invalid Event specified. If you followed a valid link, please notify the webmaster"

This is for every event, they do not show up twice, and this is on vB 3.0.3. I've check the db via phpMyAdmin and the events exist in the correct table and rows, but they just don't seem to be called correctly with the [I will be attending this event.] link. Any help would be greatly appreciated!


y2krazy 09-04-2004 06:20 PM

No one knows what I can do to help resolve this issue? :(

Pseudomizer 09-05-2004 12:41 AM

Quote:

Originally Posted by y2krazy
No one knows what I can do to help resolve this issue? :(

Are you familiar with PHP? Can you access your php.ini file on your server and do some changes?

Cheers,

y2krazy 09-05-2004 02:43 AM

What kind of changes? I am hosted by a comany named Net-Expressions and I could get the PHP Info for you, but I doubt I could edit their server's php.ini file... :confused:

SamirDarji 09-08-2004 12:16 AM

Quote:

Originally Posted by neroflorida
There appears to be a bug in the software that causes accumulation of data if:
A) Multiple Events Occur On Same Day, and
B) Events Use Roll Call Feature

Example data:

Event #1 -
Actual Roll Call: User1, User2, User3
Displayed Roll Call: User1, User2, User3

Event #2 -
Actual Roll Call: User4
Displayed Roll Call: User1, User2, User3, User4

...

Would appear that the array isn't cleared between cycles? Haven't had a chance to look at the code yet to verify.

This is interesting. I am about to install this hack on 3.0.3, but will have many events on the same day and will need to allow users to pic and choose on all of them. Has this bug been fixed?

neroflorida 09-11-2004 10:56 AM

Quote:

Originally Posted by SamirDarji
This is interesting. I am about to install this hack on 3.0.3, but will have many events on the same day and will need to allow users to pic and choose on all of them. Has this bug been fixed?

Not to my knowledge... If it doesn't get fixed by the author soon, I will fix it. ;) 'course may take a bit, I'm in florida, and it seems everytime I get working on a project we get whacked by a storm that takes out power and communications for a week :roll:

SamirDarji 09-11-2004 04:19 PM

Well, if you need any help, let me know. I'm also going to take a swing at fixing it. I'm also planning on replacing the "*" with a graphic and also making the "*" appear on the upcoming events so someone can see what's coming up and what they've already committed to.

Pseudomizer 09-11-2004 04:52 PM

Quote:

Originally Posted by SamirDarji
Well, if you need any help, let me know. I'm also going to take a swing at fixing it. I'm also planning on replacing the "*" with a graphic and also making the "*" appear on the upcoming events so someone can see what's coming up and what they've already committed to.

By the way: unregistered users can also participate on events. Every user is THE unregistered user and due to this everyone can attend an event, and another user can cancel the attendance for THE unregistered account.

Cheers,


All times are GMT. The time now is 09:23 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01240 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete