PDA

View Full Version : Poll problems


08-16-2000, 04:36 AM
<a href="http://www.gamingdreams.jumpworld.net/vb/index.php" target="_blank">http://www.gamingdreams.jumpworld.net/vb/index.php</a>

For some reason when I make a poll and Submit it, it gives me the database error, but when I preview it, it works finely. Any ideas?

08-16-2000, 04:41 AM
you seem to have more problems than that...

i visited a thread http://www.gamingdreams.jumpworld.net/vb/showthread.php?threadid=29 and got

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/gamingdreams/public_html/vb/showthread.php on line 417

Parse error: parse error in /home/gamingdreams/public_html/vb/showthread.php on line 417

08-16-2000, 04:49 AM
All right, I got it working...I was trying to fix that slash bug noted in the other thread, which I'm getting now. Let's see if I can fix that...

http://www.gamingdreams.jumpworld.net/vb/showthread.php?threadid=34

You should see slashes before all the ', otherwise, I fixed it :)

08-17-2000, 05:10 AM
the next version will have the slashes code in it, hopefully by next week or so.

08-18-2000, 12:32 PM
How did you get rid of the database problem as I'm having the same problem as you seem to of had.

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

Its driving me nuts

08-18-2000, 03:25 PM
mackx - what sort o ferror exactly? and when? and where? ;)

08-18-2000, 03:35 PM
The problem is as follows:

Database error in vBulletin: Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,lastposter,datelin e,iconid,visible)
VALUES (NULL,'Test Pol',966614484,1,1,0,'MackX','MackX',966614484,ima ges/icons,1)
mysql error: Unknown column 'images' in 'field list'
mysql error number: 1054
Date: Friday 18th of August 2000 05:01:24 PM
Script: /forums/poll.php

08-18-2000, 03:38 PM
Originally posted by MackX
The problem is as follows:

Database error in vBulletin: Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,lastposter,dateline,iconid,visible)
VALUES (NULL,'Test Pol',966614484,1,1,0,'MackX','MackX',966614484,ima ges/icons,1)
mysql error: Unknown column 'images' in 'field list'
mysql error number: 1054
Date: Friday 18th of August 2000 05:01:24 PM
Script: /forums/poll.php


Well your error is because you put in the wrong thing in the setup. Where you were told to put the iconid for the poll icon, an integer, you appear to have put "images/icons". Go back to the control panel, open the Message Icons. Put your mouse over "edit" beside the picture of the X poll icon. Write down the ID, it will be a number, such as 25. Then go to the polloptions and put that number where it asks for the poll icon id.

08-18-2000, 03:48 PM
Working now, thanks :)

08-18-2000, 04:03 PM
Originally posted by doron
the next version will have the slashes code in it, hopefully by next week or so. can't wait... been waiting for the next version to come out... :D

08-18-2000, 10:57 PM
yeah, the poll icon is annoying, gotta think of a better way. However, means more complex hacking...

Current features that are planed for next version:

.Graphical display (all templatable)
.Slash-removal everywhere
.Userfriendlier (ie ask to login when voting and not logged in)
.expire date setting on creation and on edit
.cooler installer
.on thread display, after the thread title, it will state how many votes and how many new since last visit. This is to make it easier to see if a new reply or a new vote bumped the poll up.
.Set a defauly prefix for polls (which was contributed in another thread)

hopefully will have it done in the next 2 weeks, however, I might delay it if the summer release coincides with it.

08-19-2000, 02:24 AM
love the idea of a better installer :D

08-21-2000, 05:09 AM
Doron - Are you the developer for vbb?

Kode