Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 02-16-2005, 05:53 AM
VBUsers's Avatar
VBUsers VBUsers is offline
 
Join Date: Aug 2004
Posts: 830
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default need help members get a sql error but i can see my forum

this is weird and i dont get it.

i have been doing changes to my board but i and a few can only see it. everyone else gets this

There seems to have been a slight problem with the Lowandloud.com Forums:. IDEN HQ database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


but i can browse and post etc. 90% of my members are getting this error. why? is it something i did. i did use an old database of mine with a new board. if youve seen this before let me know what to do and how to fix it.

my site is www.lowandloud.com please let me know what you see as well if you can help. thanks ahead of time
Reply With Quote
  #2  
Old 02-16-2005, 06:10 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please do a right click and view source on that error page.

It will show you the full SQL error. Post that here.

Lol, had a look myself. You are trying to integrate phpbb and vB:
Code:
Script: http://www.lowandloud.com/phpbb2/index.php
Referer: https://vborg.vbsupport.ru/showthread.php?p=612608#post612608
Anyhow, the error is that you are using an
PHP Code:
$array 
variable instead of a normal one or:
PHP Code:
$array['column'
You'll have to fix that. Can't help you more unless you post the lines from your php script.

edit: Actually your are redirecting to a phpbb page. Maybe you should ask in their support board
Reply With Quote
  #3  
Old 02-16-2005, 07:55 AM
VBUsers's Avatar
VBUsers VBUsers is offline
 
Join Date: Aug 2004
Posts: 830
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

its not phpbb i just left the folder named that when i started over with VB from phpbb. i should have changed it but i didnt want to mess anything up.

i dont know what to change and i cant get the source code casue i dont get the errors my members do. but i will ask one to post it or try from another PC to see what i get. but i see my forum on my PC with no issues. i dont get it

and this is an email im getting i have around 250 of em all the same

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT

thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview

FROM smora_thread as thread
LEFT JOIN smora_icon USING (iconid)
LEFT JOIN smora_forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN smora_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN smora_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')

WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(1,2,4,58,59,15,26,27,45,60,28,31,3,5,46,47,48,4 9,6,7,9,11,12,14,10,16,17,18,24,30,41,8,29,37,19,3 8,42,32,54,43,50,25,44,23,55,35,56,36,57,53,34,52, 39,40,20,21,22) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10

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 'Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost D

mysql error number: 1064

Date: Wednesday 16th of February 2005 01:12:10 AM
Script: http://www.lowandloud.com/phpbb2/index.php
Referer:
Username: Unregistered
IP Address: 66.135.140.240
Reply With Quote
  #4  
Old 02-16-2005, 11:26 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, that is like i replied above. Without knowing what modifications you made i can't help you.

I think you made some changes to forumdisplay.php. Post the changed code containing this query here, and i will have a look. Alternative would be to revert back to original sources.

Edit: this query will probably around line 660 of forumdisplay.php
Reply With Quote
  #5  
Old 02-16-2005, 11:39 AM
amykhar's Avatar
amykhar amykhar is offline
 
Join Date: Oct 2001
Location: PA
Posts: 4,438
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Create a test account that has the same permissions as your members. It might be a usergroup related thing or it might be based on some data that's in your user profile and not theirs.
Reply With Quote
  #6  
Old 02-16-2005, 06:32 PM
VBUsers's Avatar
VBUsers VBUsers is offline
 
Join Date: Aug 2004
Posts: 830
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the old board had u cash , whos been online for last 24, recent ban list,files list,cmps portal,email.php, affiliates hack. those are it. i dont remember changing the forum display.php. i logged out of the forum and went to the portal page and thats the only one that gives this error. the forum wich is marked index1.php is fine for not registered and regular members. but the portal is the first page everyone gets. so what can be the issue. im looking at the forum display but dont get it.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:46 PM.


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.05834 seconds
  • Memory Usage 2,207KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete