vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   vBulletin & Zoints SEO (https://vborg.vbsupport.ru/showthread.php?t=129720)

MrLeN 10-22-2006 08:42 PM
vBulletin & Zoints SEO
 
I installed Zoints SEO, but since I installed it I have been getting emails from the server saying that there is an error. Here's the error:

Code:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT linkid, name, links.catid, userid, username, dateline, links.lastpostdateline, title
FROM wgreen_adv_links AS links
LEFT JOIN wgreen_adv_links_categories AS categories USING (catid)
WHERE links.dateline > 1161230427 AND suspended = 0 AND valid = 1;

MySQL Error  : Column: 'valid' in where clause is ambiguous
Error Number : 1052
Date        : Friday, October 20th 2006 @ 07:06:27 PM
Script      : http://www.mysite.com/community/cron.php?&rand=688347
Referrer    : http://www.mysite.com/community/index.php
IP Address  : xxx.xx.xxx.xxx
Username    : Unregistered
Classname    : vb_database
I asked about this at vBulletin, but they said:

Quote:
Those are plugins and they modify the vB code and database. The 'ambiguous' error is either due to a MySQL alpha version (which you are not running) or a change made to the database by one of your plugins. Namely one of them created an extra 'valid' field.

You need to find out which plugin cause this and remove that plugin and the changes it made to the db.
So, I want to know how I can uninstall the software and repair my database.

Paul M 10-22-2006 09:43 PM
Please post specific questions about an existing modification in it's support thread.

MrLeN 10-22-2006 09:55 PM
I would like information on how to uninstall Zoints SEO.

DementedMindz 10-22-2006 10:11 PM
yeah post it in zoints thread as paul was referring too


All times are GMT. The time now is 03:10 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.01757 seconds
  • Memory Usage 1,713KB
  • 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)bbcode_quote_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