The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 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 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? |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
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 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. |
#4
|
||||
|
||||
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.
|
#5
|
|||
|
|||
i took approximately 2000 mail like this.I asked
Should i specify every table for those fields? 2000 is not a small number default vbulletin database tables have those columns but there is no problem.I dont understand |
#6
|
||||
|
||||
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. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|