vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Error (https://vborg.vbsupport.ru/showthread.php?t=258982)

floggerss 02-16-2011 04:11 PM

Database Error
 
I have two database errorrs:

1 -
Invalid SQL: SELECT postidFROM post AS postINNER JOIN thread AS thread ON(thread.threadid = post.threadid)WHERE post.userid = 5685AND post.post_thanks_amount != 0AND thread.forumid IN(1,2,3,13,95,96,97,31,22,90,33,34,36,83,84,12,32 ,10,81,91,37,11,6,26,4,23,71,75,74,80,73,54,98,5,2 9,55,57,56,58,87,60,63,62,64,65,66,67,68,69,70,24, 28,39,21,99,53,52,40,82,85,86,19,20)ORDER BY post.dateline DESCLIMIT 1000;

MySQL Error : Unknown column 'post.post_thanks_amount' in 'where clause'Error Number : 1054Request Date : Wednesday, February 16th 2011 @ 05:42:07 PMError Date : Wednesday, February 16th 2011 @ 05:42:07 PMScript : http://www.stylers.com.ar/post_thank...dthanks&u=5685

2- And the most important

SELECT album.*,
> picture.pictureid, picture.extension, picture.idhash,
> picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
> user.*
> FROM album AS album
> LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
> LEFT JOIN user AS user ON (album.userid = user.userid)
> WHERE album.state IN ('public', 'private', 'profile')
> ORDER BY
> LIMIT 0, 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 'LIMIT 0, 10' at line 10
> Error Number : 1064
> Request Date : Sunday, February 13th 2011 @ 02:35:14 PM
> Error Date : Sunday, February 13th 2011 @ 02:35:15 PM
> Script : http://stylers.com.ar/all_albums.php
> Referrer :



Lynne 02-16-2011 04:26 PM

Those errors are from modifications. You will need to post in each modification for help with the error. We cannot help you out in the main forums.


All times are GMT. The time now is 02:18 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.00972 seconds
  • Memory Usage 1,712KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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