upgrade failed... Table 'snowscan_dk.pixelpost_visitors' doesn't exist

[SnowScan]

Hi,

I just upgraded my live site and now the front end fails and gives the following error message:
Table 'snowscan_dk.pixelpost_visitors' doesn't exist

Can anyone help me, please.
I did get af full backup before upgrading (also of the database) but I would rather fix the problem than deleting and re uploading (I am not very familiar with mysql)

site: www.snowscan.dk

This is my host information (I can still log in the admin but not click the addons menu item):

URL http://www.snowscan.dk/admin/index.php
PHP-version 5.2.5 (Pixelpost's min requirement: PHP version: 4.3.0 )
Session save path /tmp
MySQL version 5.0.32-Debian_7etch4-log (Pixelpost's min requirement: MySQL: 3.23.58 )
GD-lib bundled (2.0.34 compatible) with JPEG support
File Uploads to Pixelpost site are possible.
Server Software Apache
EXIF Pixelpost is using exifer v1.5 for EXIF-information.


Peter

[Dkozikowski]

As the message states, the visitors database table does not exist. The upgrade should not have removed it. Did you switch to a new table prefix?

Anyway, open your database backup and find the code for the visitors table. Copy this block of code. It may be large. It all depends on how much traffic you receive.

So, with this code, open your pixelpost database with phpmyadmin or the like and run an SQL query with the copied code.

It would probably be wise to make a backup of the "broken" database as well before you begin to attempt the repair.

[SnowScan]

Hmmnn I just did what you said - just the tables without the data.
I could not find it in the backup I took today, so I got back in time. so much for backing up :(

It is working again, thanks

[Dkozikowski]

So you downgraded? What version are you trying to upgrade from?

I'm stuck on this POS iPhone otherwise I'd give you a SQL query to run and fix your problem.

[Dkozikowski]

OK, Back on a computer for a short while.

If you run into the same upgrade problem, here is a query you can run to create the visitors table.

The table will be empty but your photoblog will be functional.

Notice the table prefix snowscan_dk.pixelpost_
If you use a different table prefix, change this line. Your prefix is defined within your pixelpost.php file.


CREATE TABLE snowscan_dk.pixelpost_visitors (
`id` INT(11) NOT NULL auto_increment,
`datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`host` VARCHAR(100) NOT NULL DEFAULT '',
`referer` VARCHAR(255) NOT NULL DEFAULT '',
`ua` VARCHAR(255) NOT NULL DEFAULT '',
`ip` VARCHAR(255) NOT NULL DEFAULT '',
`ruri` VARCHAR(150) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
INDEX(datetime),
INDEX(referer),
INDEX(ip))

[SnowScan]

Actually I just fixed the table, so no downgrading for me :)

Du you have a complete list of the tables there should be in a default installation? Just to check if I am missing something...

Thanks for your energetic responses :)

Peter

[Dkozikowski]

Do you have a complete list of the tables there should be in a default installation? Just to check if I am missing something...

Peter

(remember pixelpost_ is the default table prefix. This may be different if your prefix was altered.)

Pixelpost v1.7 RC1 Database Table Structure

pixelpost_addons
pixelpost_banlist
pixelpost_catassoc
pixelpost_categories
pixelpost_comments
pixelpost_config
pixelpost_ping
pixelpost_pixelpost
pixelpost_stats
pixelpost_tags
pixelpost_version
pixelpost_visitors

[SnowScan]

thanks