I just installed my database on a new server... it's taken me over a week to figure out why it wouldn't work (airhead disease or something, but I'm not really php or sql literate - I just do what you guys say and yes I followed ALL the directions to a 'T'! ), but this time it finally went INCLUDING the load of the sql database! Hurrah.. or so I thought. I grabbed the fix cache key utility and went to run it, but even just trying to get to the test directory I loaded the whole thing to of www.sonlightmall.com/store I'm now getting this:
1146 Table 'captiva1_zenstore.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]
I orginally couldn't get the sql database to load. The original file gave me this error:
*****************************************************
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 06, 2006 at 12:40 AM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `forex4_captivateuzencart`
--
CREATE DATABASE `forex4_captivateuzencart` ;
MySQL said:
#1044 - Access denied for user 'captiva1'@'localhost' to database 'forex4_captivateuzencart'
******************************************************
and had this at the beginning of the sql database:
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 06, 2006 at 12:40 AM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `forex4_captivateuzencart`
--
CREATE DATABASE `forex4_captivateuzencart`;
USE forex4_captivateuzencart;
------------------------------------------------------------------------------------
so I changed the beginning of the mysql file to this:
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 06, 2006 at 12:40 AM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `captiva1_zenstore`
--
USE forex4_captivateuzencart;
------------------------------------------------------------------
(I took the create out and changed the database name to the new database)
and then I got this:
********************************************************
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 06, 2006 at 12:40 AM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `captiva1_zenstore`
--
USE forex4_captivateuzencart;
MySQL said:
#1044 - Access denied for user 'captiva1'@'localhost' to database 'forex4_captivateuzencart'
********************************************************
So... I again messed with the mysql file and changed it to this:
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 06, 2006 at 12:40 AM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `captiva1_zenstore`
--
USE captiva1_zenstore;
--------------------------------------------------------------------------------------
Tried to import it one last time and I got this:
********************************************************
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:21) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1039
********************************************************
3 strikes and I'm out and I have to get up in 4 hours to go to work at a new job, so someone PLEASE HELP! I know it's gotta be something small I'm just missing and you guys are my saviors and have been since I started using zen.
If you need any more info please let me know but I won't be back until late tomorrow night. I just thank goodness I didn't try this on a live server.
Thanks in advance.
Tina
Bookmarks