vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   What is The Problem(s)? :( (https://vborg.vbsupport.ru/showthread.php?t=126005)

Cagonni 09-07-2006 01:52 AM
What is The Problem(s)? :(
 
Code:
Database error in vBulletin 3.6.0:
Invalid SQL:
  SELECT post.*
  FROM post AS post
  LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
  WHERE threadid = 8
  AND dateline > 1155014895
  AND visible = 1 AND deletionlog.primaryid IS NULL
  AND postid <> 10
  ORDER BY dateline DESC
  LIMIT 1;
MySQL Error  : Column: 'dateline' in where clause is ambiguous
Error Number : 1052
Date        : Wednesday, August 9th 2006 @ 12:28:15 AM
Script      : --
Referrer    : --
IP Address  : xxx.xxx.xxx.xxx
Username    : name
Classname    : vb_database
im boring of this db error :(
i searched the forum and all the sites about vbulletin.The problem is "Prevent Double Post" they said.I disabled the plugin but the error is continuing..I think My other plugins and products dont give that error.Do Prevent Double Post Plugins tables remained in my database?

Another Question

I cant make two post consecutively.Its not a time problem.After 2 or 3 days from my first posts if there is any post after mine i cant post any message :(

The Error above quick reply part is

Code:
The following errors occurred when this message was submitted

Okay
But there isnt any error it shows :(

when I click the "Okay" all it does is go back to the normal quick reply box.

Do You Have Any Ideas With These Problems?

Adrian Schneider 09-07-2006 01:57 AM
The post and deletelog tables both have a 'dateline' column, so you need to specify which one. [sql]SELECT post.*
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 8
AND post.dateline > 1155014895
AND visible = 1 AND deletionlog.primaryid IS NULL
AND postid <> 10
ORDER BY post.dateline DESC
LIMIT 1;[/sql]

I'm not sure about the other problem.

Cagonni 09-07-2006 02:23 AM
Code:
Database error in vBulletin 3.6.0:

Invalid SQL:

                      SELECT post.*
                      FROM uzakdurpost AS post
                      LEFT JOIN uzakdurdeletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
                      WHERE threadid = 5503
                              AND dateline > 1157509558
                              AND visible = 1 AND deletionlog.primaryid IS NULL
                      ORDER BY dateline DESC
                      LIMIT 1;

MySQL Error  : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date        : Thursday, September 7th 2006 @ 05:25:58 AM
Script      : http://www.hitportal.net/newreply.php
Referrer    : http://www.hitportal.net/showthread.php?t=5503
IP Address  : xx.xx.xx.xxx
Username    : Cagonni
Classname    : vb_database
This is the mail i read.Your sql code includes

WHERE threadid = 8
AND post.dateline > 1155014895

should i do this for all threadid an post datelines?For example

WHERE threadid = 5503
AND dateline > 1157509558

because this error valid for all my forum categories.

Adrian Schneider 09-07-2006 02:26 AM
Specifying every table for those fields isn't a bad habbit - but you only have to do the ones that are in both tables (such as dateline). I don't understand your question... I'm not sure what you are trying to do.

Cagonni 09-07-2006 02:32 AM
i took approximately 2000 mail like this.I asked

Should i specify every table for those fields? 2000 is not a small number :confused:

default vbulletin database tables have those columns but there is no problem.I dont understand :(

Adrian Schneider 09-07-2006 02:43 AM
vBulletin includes the table when specifying the field, which you are not.

If two tables both have the same field name, and you don't tell it which table the field belongs to, it will give you an error like the above.

You can specify the table only for problematic queries like that one. To be safe, you should do it for all of your queries using more than one table.


All times are GMT. The time now is 07:09 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.01250 seconds
  • Memory Usage 1,723KB
  • 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
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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