![]() |
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??? |
NB: This is also intergated with the Calendar to Thread Hack which was working fine...
|
Quote:
-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. |
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|