Installation Error from vbsc2-vbsc3

**Mike Sullivan** · Mon 14 May '01, 7:39am

What was the error you were emailed?

**tubedogg** · Mon 14 May '01, 7:39am

You will need to view the source of the error page and copy and paste that here, or copy and paste the email you (should have) received that also contains the error. That message is just vB's nice way of telling you there's an error.

**datman99** · Mon 14 May '01, 7:44am

Thanks...here's the error stuff

Email message:
===============

Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO template (templatesetid,title,template) VALUES (-1,'forumdisplay_sortarrow','<a href=\"$sorturl&sortorder=$oppositesort&sortfield=$sortfield\"><img src=\"{imagesfolder}/firstnew.gif\" alt=\"Reverse sort order\" border=\"0\" align=\"middle\"></a>')
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Monday 14th of May 2001 09:51:00 AM
Script:
Referer: http://www.singlebrotha.com/forums/a...de8.php?step=2

Source code from the index page (index.php)
===================================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>

Help!
Datman

**Mike Sullivan** · Mon 14 May '01, 7:57am

Try that step again -- that's a very small template and that shouldn't happen.

**datman99** · Mon 14 May '01, 7:57am

Just noticed.......this

There is not file named install1.php in the vbsc3 zip. All i see is install.php and that is the file that gave me the initial error. Is this the correct file name?

Datman

**datman99** · Mon 14 May '01, 8:02am

I did.....but.....

It just returned the same error. Infact my email box is flooded with me trying to rerun tha step#3.

SIDE NOTE: My KEYWORD search has been down since I upgraded to vbc2. It was working before I did that upgrade and now this is erroring out? Can this be releated?
What do ya think?

Datman

**datman99** · Mon 14 May '01, 8:36am

Ed, here's some good news! I can get to the following pages, just by typing the exact urls into the browse.

Register
Calendar
Top Members
FAQ
Search

**Mike Sullivan** · Mon 14 May '01, 8:38am

I don't know what to say -- I've seen that error before but it only happened on the faq pages. You already inserted templates larger than that one without a problem...

**datman99** · Mon 14 May '01, 8:45am

Cool, just tell me how to get the the index.php to run again...right now it's showing blank to me and all members.....

Help me............Obei Wan

Datman

**datman99** · Mon 14 May '01, 8:51am

New Error

Database error in vBulletin Control Panel: Invalid SQL: DELETE FROM template WHERE templatesetid=-1 AND title<>'options'
mysql error: Incorrect key file for table: 'template'. Try to repair it
mysql error number: 1034
Date: Monday 14th of May 2001 11:48:53 AM
Script:
Referer:
==================

**Mike Sullivan** · Mon 14 May '01, 8:54am

Run myisamchk (or isamchk if it's an ISAM table) or repair.php on the template table.

**datman99** · Mon 14 May '01, 8:57am

Okay...now ya talking greek to me...

Huh?

Were do I run those?
Ed, do you charge to fix errors like this?? if so how much is your rate? I can geive you acces to my domain and you can earn some quick cash to fix this.

Email me at: [email protected]

ASAP.
Thanks

Datman

**datman99** · Mon 14 May '01, 12:47pm

*bump*

**roy7** · Mon 14 May '01, 1:48pm

Your template file is corrupt. myisamchk and isamchk are the tools to repair them.

I assume you are using MYI.

Take mysql down
Go to your mysql data directory
myisamchk -r forum/*.MYI
restart mysql

However, recent versions of mysql should allow you to type "repair table template". Try that first.

-Jonathan

Installation Error from vbsc2-vbsc3

Installation Error from vbsc2-vbsc3

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Related Topics