vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   v1.0 Add Meeting Place, Time or Game fields to Calendar (https://vborg.vbsupport.ru/showthread.php?t=57595)

DaveLogic 11-14-2003 08:17 AM

Everything seems to work except that I can only enter numbers into the new fields icluding the Subject box. As soon as I enter any form of text I get the following error

Database error in vBulletin 2.3.2:

Invalid SQL: INSERT INTO calendar_events (userid, event, eventdate, public, subject, allowsmilies, venue, weekday, time, lineup, cost)
VALUES ('1', 'Test', '2003-11-14', 1, 'Test', 1, Test, Test, Test, Test, Test)
mysql error: Unknown column 'Test' in 'field list'

mysql error number: 1054

Date: Friday 14th of November 2003 09:56:36 AM
Script: http://localhost/forums/forums/calendar.php
Referer: http://localhost/forums/calendar.php...dd&type=public


I've uninstalled/reinstalled the hack twice and also tried with the default settings i.e "Meeting" but still get the same error. I've also checked Mysql and all set to VARCHAR. Tried with TEXT but made no difference....Any ideas???

DaveLogic 11-14-2003 08:19 AM

NB: This is also intergated with the Calendar to Thread Hack which was working fine...

LeMans350z 11-16-2003 12:27 AM

Quote:

Originally Posted by DaveLogic
Everything seems to work except that I can only enter numbers into the new fields icluding the Subject box. As soon as I enter any form of text I get the following error

Database error in vBulletin 2.3.2:

Invalid SQL: INSERT INTO calendar_events (userid, event, eventdate, public, subject, allowsmilies, venue, weekday, time, lineup, cost)
VALUES ('1', 'Test', '2003-11-14', 1, 'Test', 1, Test, Test, Test, Test, Test)
mysql error: Unknown column 'Test' in 'field list'

mysql error number: 1054

Date: Friday 14th of November 2003 09:56:36 AM
Script: http://localhost/forums/forums/calendar.php
Referer: http://localhost/forums/calendar.php...dd&type=public


I've uninstalled/reinstalled the hack twice and also tried with the default settings i.e "Meeting" but still get the same error. I've also checked Mysql and all set to VARCHAR. Tried with TEXT but made no difference....Any ideas???

Ok I had the same error. There is a couple of errors in the install file.
-1-
++++++++++++++++++++++++++
Step 8:
Find:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies


AND REPLACE WITH:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies, '$eventtime', '$ampm', '$eventzone'

++++++++++++++++++++++++++
Single Quote missing from $eventtime, $ampm, $eventzone

-2-
++++++++++++++++++++++++++
Step 8:
Find:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies


AND REPLACE WITH:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies, '$meeting'

++++++++++++++++++++++++++
Single Quote missing from $meeting

SO any new fields you created need the single quotes on step 8. I would assume the -3- step requires the same modification however I did not use it so I didn't look. Hope that helps.

DaveLogic 11-17-2003 06:42 AM

Many thanks for your reply...Got it sorted now....thanks


All times are GMT. The time now is 08:26 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.02152 seconds
  • Memory Usage 1,725KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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