vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Help Parse Error!! (https://vborg.vbsupport.ru/showthread.php?t=43421)

chad777 09-11-2002 10:14 AM
Help Parse Error!!
 
PHP Code:
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,NP,allowsmilie,showsignature,ipaddress,iconid,visible,usermoodid,usermoodpath,usermoodmessage) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername))."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','".addslashes($nowplaying)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible','$usermoodid','$usermoodpath','".addslashes(htmlspecialchars($usermoodmessage))."')"); 
Can anyone tell me where the error is in this please ???

Its been driving me crazy

error I am getting is Parse error: parse error, unexpected ')' in /home/ravescen/public_html/newreply.php on line 336

chad777 09-11-2002 10:31 AM
nevermind i found it the above error now I am getting another error about wrong syntax can anyone look at this and see if they see anything wrong thanks

g-force2k2 09-11-2002 01:58 PM
the query looks okay to me...what kind of sytax error is it giving you? regards...

g-force2k2

chad777 09-11-2002 02:06 PM
well i fixed that one. now I am having a problem with newtread after installing the sticky thing.

at around line 287:

PHP Code:
$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach,sticky) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount','$stickynow')"); 
everytime i try to start a new tread (push the submit buttom) I get this database error:

Database error in vBulletin 2.2.6:

Invalid SQL: select uid, newthread from storepoint where uid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

g-force2k2 09-11-2002 02:10 PM
thats because the uid value that you're trying to select either is getting the wrong variable or doesn't exist... it doesn't have to do with the INSERT INTO thread query... regards...

g-force2k2

chad777 09-11-2002 02:20 PM
Have any idea what I should look for to check if it is right like [userid]

The reason I was looking at the query is because there was a database error before the one above before that, that said that line.....then i fixed or atleast I thought and now i get that error

chad777 09-11-2002 02:24 PM
The only things that have uid= in them are:

PHP Code:
$gettotalpoint=mysql_query("SELECT uid, newthread, reply, admin_mod, morereply from storepoint where uid=$bbuserinfo[userid]"); 
PHP Code:
$result=$DB_site->query("select uid, newthread from storepoint where uid=$postuserid"); 
PHP Code:
$DB_site->query("UPDATE storepoint SET newthread=$newpoints where uid=$postuserid"); 

g-force2k2 09-11-2002 02:25 PM
chad open the file that the error was in and find that select query and post it here so i can see whats up with it... regards...

g-force2k2

chad777 09-11-2002 02:28 PM
here is the whole newthread.php file

:)

g-force2k2 09-11-2002 02:32 PM
first of chad please remove the file you can't post full vb files just don't want you to get in trouble ;) second find this:

PHP Code:
                                $gettotalpoint=mysql_query("SELECT uid, newthread, reply, admin_mod, morereply from storepoint where uid=$bbuserinfo[userid]"); 
replace it with this:

PHP Code:
                                $gettotalpoint = $DB_site->query_first("SELECT uid, newthread, reply, admin_mod, morereply FROM storepoint WHERE uid='$bbuserinfo[userid]'"); 
see if that works regards...

g-force2k2

chad777 09-11-2002 02:40 PM
Database error in vBulletin 2.2.6:

Invalid SQL: select uid, newthread from storepoint where uid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

same...

I have noticed when I do start a new thread it does the post the thread even though it errors. :(

chad777 09-11-2002 02:51 PM
the new thread post but nothing as the message if that helps any

g-force2k2 09-11-2002 03:37 PM
just pm me the file this time ;) so i can look through it and see what i can do... regards...

g-force2k2


All times are GMT. The time now is 01:17 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.01328 seconds
  • Memory Usage 1,752KB
  • 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
  • (7)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (13)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete