Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Cannot Delete Threads Any More. Big Problem. Please Help me out. Details »»
Cannot Delete Threads Any More. Big Problem. Please Help me out.
Version: , by BigJohnson BigJohnson is offline
Developer Last Online: Jun 2004 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 09-28-2002 Last Update: Never Installs: 0
 
No support by the author.

Ok I am not to sure what my last couple of hacks I installed were but Now I try to delete my threads and I cannot. This is a big problem for me due to the amount of space I have left on my server. When i go to a post and i click on EDIT button on the first post of the thread. There is a box above saying do you want to delete this thread. And then you check the box and click UPDATE or what ever. I get this error after updating

Database error in vBulletin 2.2.5:

Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0) AND postid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

I am not to sure what it means. I went to my PHPMYADMIN and went to searchindex and I just see 3 columns that say wordid, postid, and intitle. I am not to sure what the error is but does anyone think they can help me out. I believe my last hack i installed was the Custom Post Prefixes But i deleted it to see if that was the problem and it wasn't. PLease help me out someone. I am desparate for your skill. Thanks.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 09-28-2002, 01:25 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

perhaps your host has upgraded to php42x
vb225 isn't compatible with this version, you should upgrade to vb228.

also because of some security fixes you should really upgrade
Reply With Quote
  #3  
Old 09-29-2002, 12:36 PM
BigJohnson BigJohnson is offline
 
Join Date: Nov 2001
Posts: 535
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nope this is not the propblem. I am running ona 2.2.5 and I installed 2.2.4 just to make sure and that works fine when i make a post and delete. IT has to be something else. Can someone maybe help me out please. Or can somoene tell me how the process of deletin a thread goes so I can fix the problem myself maybe.

This is what i have so far. When u click edit and delete it says u have an SQL error in your edit.php

When i go to admin options down below and delete thread there it says there is a sql error but for the postings.php file. What is up.
Reply With Quote
  #4  
Old 09-29-2002, 02:09 PM
Bison's Avatar
Bison Bison is offline
 
Join Date: Jun 2002
Location: Virginia Beach, Virginia
Posts: 522
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Make a Backup of those two files and replace them with the original files ...

if the delete process works, there might be a compatibility problem with a applied hack. Compare the two files to see the diference between the two files. Re-appy each change you made to the old version (one at a time and save) to the original version to locate the source error.

Test each sequence (creating test threads to delete) untill you find the root of your problem ...

Hope this helps!
Reply With Quote
  #5  
Old 09-29-2002, 02:12 PM
BigJohnson BigJohnson is offline
 
Join Date: Nov 2001
Posts: 535
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nope because I still get this error when i replace the files. Damn. This sucks
Reply With Quote
  #6  
Old 09-29-2002, 03:58 PM
BigJohnson BigJohnson is offline
 
Join Date: Nov 2001
Posts: 535
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have fixed the problem. Thanks for your help.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:22 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04465 seconds
  • Memory Usage 2,244KB
  • Queries Executed 21 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (5)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete