GIGJ.COM
welcome to my space |
upgrade failed... Table 'snowscan_dk.pixelpost_visitors' doesn't exist | | Published by: wktd 2009-01-07 |
| | Pixelpost Forum Pixelpost Help Page 51::
Page 51-Having trouble? Post what you cannot figure out here, the remedy upgrade failed Table snowscan_dk.pixelpost_visitors doesnt exist. SnowScan
http://www.pixelpost.org/forum/forumdisplay.php?f=10&order=desc&page=51HOME |
Hi,
I just upgraded my live site and now the front end fails and gives the following error message:
Pixelpost Forum Pixelpost Help Page 53::
Page 53-Having trouble? Post what you cannot figure out here, the remedy upgrade failed Table snowscan_dk.pixelpost_visitors doesnt exist. SnowScan
http://www.pixelpost.org/forum/forumdisplay.php?f=10&order=desc&page=53HOME |
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
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.
Pixelpost Forum upgrade failed Table snowscan_dk ::
upgrade failed Table snowscan_dk.pixelpost_visitors doesnt exist Pixelpost Help upgrade failed Table snowscan_dk.pixelpost_visitors doesnt
http://www.pixelpost.org/forum/showthread.php?t=7655HOME |
Pixelpost 1.7.x [Archive] - Pixelpost Forum::
upgrade failed Table snowscan_dk.pixelpost_visitors doesnt exist. Emails sent on comments Table shanghaiviva.0409pixelpost08_ping doesnt exist
http://www.pixelpost.org/forum/archive/index.php/index.php?f-46.htmlHOME |
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))
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
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
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.
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.
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
thanks
 Nortel Unveils Vision, Strategy for Israeli High-Performance Net
 Busy Friday Leads to Strong Close for Net Stocks
|
You are looking at:gigj.com's upgrade failed... Table 'snowscan_dk.pixelpost_visitors' doesn't exist, click gigj.com to home
|
#If you have any other info about this subject , Please add it free.# | |
|
