After doing everything BY THE BOOK (According to IP's upgrade information) I have had enough with the issues which remain unanswerd which were produced durring the 1.3 upgrade I can not afford the downtime....
I posted 3 days ago looking for feedback however It still remains unanswered, could not afford to wait as people USE the website every day "or did until this fabulous upgrade...."
Have worked the last 2 DAYS to restore my IP 1.2.0.27c website (from my FULL BACKUPS of the entire site as well as the database itself "saved from within IP ACP System 3x to be safe) yeah know they only gave us 100 warnings to BACK UP EVERYTHING JUST INCASE...
Im using the SAME ACCOUNT, SAME URL, THERE HAS BEEN NO CHANGES SERVER WISE and 1.2.027c had ran flawlessly since Jan09 when I decided to try out IP....
WTH good is it if the BACKED UP DATABASE SCRIPT HAS ERRORS IN IT FROM THE START? what the heck am I missing here?
I am not running any MODS nor have I made ANY MODIFICATIONS to IP Core Scripts (everything is STOCK Per INSTALL). The only addons are a few TEMPLATES which were downloaded from this site (and to date have been flawless).
For the record (After the issues I ran into with 1.3) before I attempted to Restore my original files I DELETED ALL FILES FROM THE SITE ROOT BEFORE UPLOADING my 100% COMPLETE BACKUP FILES..... Yes this also includes "as directed" my htaccess and config.php files...
as well as full permissions have been verified...
Install.php was run to reestablish full conectivity since simply uploading my files to the same diretory they came from in the first place resulted in NO ACP access let alone site access itself. Figured "reestablish access, UPLOAD MY BACKED UP DATABASE with its 200+ User profiles & 2000+ POSTS
The database itself is 15mb+, Restoring it via phpmyadmin via my host isn't possible due to PHP/SQL limitation issues 1and1.com will accept up to 8mb max so using "AS SUGGESTED BY THIS SITE: MYSQL BIG DUMP".
The Downloaded BACKUP file ZIPED is aprox 1.5mb, UNZIPED 15mb... Have attempted to RESTORE the database via ACP appears to be uploading everything however when I check the database itself? It shows all of 400kb "ish" in size has been restored *also to make sure I was not looking at something the wrong way "Backed up the current database to see what the file size was... same as posted above aprox 400kb...
First attempt was directed to the Target database, with this error posted below, 2nd & 3rd attempt was targeted at 2 new databases "one configed as MySQL4, the other MySQL5, simply to eliminate that factor as a possible problem... BOTH tests ending the same as the 1st with the ERROR LISTED BELOW....
Attempt 2 & 3 were done with BRAN NEW DATABASES, So there WERE NO TABLES in them to be issues "so it isn't that"...
ERROR////////////////////////////////////////////////////////////////////////////////////////////
BigDump: Staggered MySQL Dump Importer v0.29b
Processing file: backup_1248615578_20090726_181390701a0ba9a9.sql
Starting from line: 3001
Error at the line 3828: );
Query: CREATE TABLE ip_force_read_users(
user varchar(255) DEFAULT '' NOT NULL,
read int(1) DEFAULT '0' NOT NULL,
time int(10) DEFAULT '0' NOT NULL
);
MySQL: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'read int(1) DEFAULT '0' NOT NULL, time int(10) DEFAULT '0' N
Stopped on error
Start from the beginning (DROP the old tables before restarting)
2003-2008 Alexey Ozerov - BigDump Home
END ERROR///////////////////////////////////////////////////////////////////////
(DROP the old tables before restarting?) kind of hard to do that with 2 NEW DATABASES with NOoooooo Tables in them what so ever....
Current Status of my site: I can access it (after 2 days of screwing with it I now have ACP ACCESS AGAIN..... ) Album/Gallery can be accessed, all files and pics appear to be present, NO USER ACCOUNTS EXSIST "other than my own" Forum Headers/Topics/Categories EXSIST "they also ALL STATE x Number of posts X number of topics of what should be in each forum however when you click on ANY of them, there is absolutely NOTHING posted....
So, considering that MY SITE has been OFFLINE since TUESDAY MORNING with many people who access it EVERY DAY WAITING, it's now THURSDAY wth is the REAL DEAL with restoring an IP WEBSITE? "I am no noob however I am NOT a SQL DATABASE GURU" I have Migrated, Restored, and BUILT a number of WEBSITES over the years "using prefab GNU based CMS cores" and have never had this much of a problem as I have with this Icy Phoenix CMS....
The core itself is amazing, feature and config wise but isn't any good if it takes days to fix simple problems......
If there is ANYONE who can shed some light on "what it is I may be doing wrong or what I am missing here" The feedback would be a huge help as my WEBSITE is WORTHLESS if it cannot be accessed by the users who support it.......
Thx in advance.........