Database Problems...

**Jake Bunce** · Sat 3 Jul '04, 8:38am

The session and cpsession tables will always return errors, that's normal. But the two views tables have problems.

If running the repair again does not fix the problem then those tables cannot be repaired and you need to restore a backup of your database. The command to restore a backup is detailed on this page.

**LadyBug** · Sat 3 Jul '04, 8:52am

Pff i have no recent backup...
Have to import my phpBB agian i guess...

Hope its over, i had never problems with phpBB2...

**Zachery** · Sat 3 Jul '04, 8:55am

You dont need to reimport a backup.

You should be able to drop and recreate each of thoughs tables.

Let me see if i can find the instructions

For threadviews

Code:

DROP TABLE IF EXISTS threadviews;
CREATE TABLE threadviews (
threadid INT UNSIGNED NOT NULL DEFAULT '0',
KEY threadid (threadid)
);

for attachmentviews

Code:

DROP TABLE IF EXISTS attachmentviews;
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (attachmentid)
);

**Jake Bunce** · Sat 3 Jul '04, 10:14am

Just keep in mind that if you recreate those tables then you will lose their information. So basically your thread and attachment views will be reset.

**Zachery** · Sat 3 Jul '04, 10:14am

They are gone as it is O.o

**Michael König** · Sat 3 Jul '04, 11:48am

Originally posted by Jake Bunce

So basically your thread and attachment views will be reset.

Actually they are stored in thread.views and attachment.counter.

The table threadviews is used for the hourly update of the thread view counter, if "Update Thread Views Immediately" is disabled.
The table attachmentviews is used for the hourly update of the attachment view counter, if "Update Attachment Views Immediately" is disabled.

After each of the two updates, these tables will be emptied anyway, so I don't think he has lost much

**erkme73** · Fri 4 Mar '05, 3:11pm

Originally posted by Zachery

You dont need to reimport a backup.

You should be able to drop and recreate each of thoughs tables.

Let me see if i can find the instructions

For threadviews

Code:

DROP TABLE IF EXISTS threadviews;
CREATE TABLE threadviews (
threadid INT UNSIGNED NOT NULL DEFAULT '0',
KEY threadid (threadid)
);

for attachmentviews

Code:

DROP TABLE IF EXISTS attachmentviews;
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (attachmentid)
);

I know I'm late to the party, but how and where to you apply this code? I have an error in the exact same two tables. Is this done through the admin panel, through FTP, or via myphpadmin?

Thanks!!

----

Nevermind - I found out how to execute an SQL command on my own through the myphpadmin. thanks for the code!!!

**Steve Machol** · Fri 4 Mar '05, 5:31pm

Those are queries. You can run them in the SQL tab in phpMyAdmin.

**erkme73** · Fri 4 Mar '05, 5:33pm

Originally posted by Steve Machol

Those are queries. You can run them in the SQL tab in phpMyAdmin.

Thanks again Steve - that's two today that you answered nearly immediately. Thanks!!!

**Milez** · Sun 17 Apr '05, 10:54am

argh

THis is what I get when trying to fix my attachmentID problem. I get about 300 emails/day for months now.

Code:

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax near ';
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0' at line 1

Database Problems...

Database Problems...

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment