vb.org Archive - Keep getting this SQL DB error emailed to me

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

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

- - Keep getting this SQL DB error emailed to me (https://vborg.vbsupport.ru/showthread.php?t=271912)

mikeee

10-12-2011 09:41 PM

Keep getting this SQL DB error emailed to me

Just upgraded to 4.1.7 and I am getting this error email about 40 times a day and I cant find the error, I visit the referring URL and it works fine. No complaints from the board members either.

Any ideas?

Code:

Database error in vBulletin 4.1.7:



Invalid SQL:



        SELECT infractionid, infraction.userid, points, username

        FROM CSR_infraction AS infraction

        LEFT JOIN CSR_user AS user USING (userid)

        WHERE expires <= 1318461771

                AND expires <> 0

                AND action = 0;



MySQL Error   : Column 'points' in field list is ambiguous

Error Number  : 1052

Request Date  : Wednesday, October 12th 2011 @ 06:22:51 PM

Error Date    : Wednesday, October 12th 2011 @ 06:22:51 PM

Script        : http://www.MyWebsite.com/cron.php?rand=1318461424

Referrer      : 

IP Address    : 150.70.75.37

Username      : Unregistered

Classname     : vB_Database

MySQL Version :

Lynne

10-12-2011 10:21 PM

Sounds like you have added a field called points to your user table and that is causing issues with some default vb code. Change that query to say "infraction.points" instead of just "points" and it should be fine.

mikeee

10-12-2011 10:53 PM

Thank you very much! Now... where do I find this query? Its not in cron.php and its not in includes/functions_cron.php either.

Lynne

10-13-2011 01:51 AM

Just do a search in your files using your text editor (most should allow you to search directories). It is one of the cron jobs in the includes/cron directory.

All times are GMT. The time now is 08:08 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01780 seconds Memory Usage 1,709KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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: