vb.org Archive - (Help) Database Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - (Help) Database Error (https://vborg.vbsupport.ru/showthread.php?t=137381)

gbml4u

01-24-2007 06:34 AM

(Help) Database Error

I got this problem on my site and i dont know how to fix it...if anybody knows how to fix them pls needing ur helps..

Code:

Invalid SQL:



                SELECT

                        user.username, (user.options & 512) AS invisible, user.usergroupid,

                        session.userid, session.inforum, session.lastactivity,

                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS 

displaygroupid, infractiongroupid

                FROM session AS session

                LEFT JOIN user AS user ON(user.userid = session.userid)

                WHERE session.lastactivity > 1169626756

                ORDER BY username ASC;



MySQL Error  : Unknown column 'user.username' in 'field list'

Error Number : 1054

thanks in advanced

webmazter

01-24-2007 07:01 AM

Code:

ORDER BY user.username ASC;

gbml4u

01-24-2007 07:05 AM

what the f**kin gonna in here ? i asked a firm to build for me a site and paid them the money for this and lisence, so i got this one, thanks for the information, now im trying to get back the money :(

webmazter

01-24-2007 07:14 AM

Quote:

Originally Posted by gbml4u (Post 1166264)

chill out, have you tried my suggestion above?

gbml4u

01-24-2007 07:18 AM

but i dont know how to fix it :( or try to reinstall the Vbb ?

webmazter

01-24-2007 07:21 AM

Quote:

Originally Posted by gbml4u (Post 1166270)

but i dont know how to fix it :( or try to reinstall the Vbb ?

Don't think you need to reinstall VB.

What add-ons are installed on the VB?

gbml4u

01-24-2007 07:26 AM

nothing...because i created this two days ago, and all set by default. Maybe a languague scripts :) but its not add-ons. I just edited and added some cripts in footer of template.

webmazter

01-24-2007 07:31 AM

try reverting the templates changed one by one. After each reverted, try to access the problem page again.

If it's just a clean install from two days ago, then you can reinstall VB and forget all the hassles. But you need to re-configure your modifications.

You said you paid the firm money for the license and the site. Did you download the script directly from vbulletin.com members area or the script provided by the firm?

If it's provided by the firm, then those scripts may have been tampered. :)

gbml4u

01-24-2007 07:35 AM

i downloaded this scripts from a site, not from vbulletin and i installed it by myself. I think the best way it to reinstall it now. thanks so much 4 ur help. Wish u all the best, guy.

All times are GMT. The time now is 09:41 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01124 seconds Memory Usage 1,726KB 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 (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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
Messages: