New Day / New Problem - DB errors

[Stuff4Toys]

First off, I want to thank all who have helped me so far... THANKS!

[Problem 1:] My host is Go Daddy
[Problem 2:] No one there would tell me the database server name to set up the install. I went through Metropolis install and set up the server & db. Hacked the admin/includes/configure.php to get the server info.

ftp'd my existing setup from my test server to the domain at go daddy and over wrote all the files. edited the configure.php in the admin/includes AND ../includes

[Problem 3:] In Go Daddy's MySQL PHPAdmin Go Daddy removed the IMPORT link from the console page. I did find "Show Processes" and "Edit" to import and sql query.

I went to my test server and after 12 attempts, I landed on a combination of check boxes that Go Daddy would not spit up on.

I did a complete "Drop Table" and "Create Table" with "Complete inserts" and "Extended inserts"

And reported NO ERRORS! COOL!!!

Data was there, but the site was not displaying side boxes or images.
Did a ZC_Install and performed an upgrade.

The site is up and running! Hooray!!!

[Problem 4:] Admin login worked OK, BUT when I try and click on ANY option I get...

1062 Duplicate entry '0' for key 1
in:
[insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'currencies.php', '', '66.208.65.216')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

HELP, now what do I do???

All your help is certainly appreciated. If anyone wants to talk person to person, PM me and I will get you a phone number.

JOhn ><>

[Stuff4Toys]

Here is the portion of the sql query that concerns the zen_admin_activity_log table.


-- Table structure for table `zen_admin_activity_log`
--
DROP TABLE IF EXISTS `zen_admin_activity_log`;
CREATE TABLE `zen_admin_activity_log` (
`log_id` int(15) NOT NULL,
`access_date` datetime NOT NULL default '0001-01-01 00:00:00',
`admin_id` int(11) NOT NULL default '0',
`page_accessed` varchar(80) NOT NULL default '',
`page_parameters` varchar(150) default NULL,
`ip_address` varchar(15) NOT NULL default '',
PRIMARY KEY (`log_id`),
KEY `idx_page_accessed_zen` (`page_accessed`),
KEY `idx_access_date_zen` (`access_date`),
KEY `idx_ip_zen` (`ip_address`)
) TYPE=MyISAM AUTO_INCREMENT=6708 ;
--
-- Dumping data for table `zen_admin_activity_log`
--
INSERT INTO `zen_admin_activity_log` (`log_id`, `access_date`, `admin_id`, `page_accessed`, `page_parameters`, `ip_address`) VALUES (6687, '2007-05-24 13:59:37', 1, 'store_manager.php', '', '192.168.0.73'),
(6688, '2007-05-24 13:59:55', 1, 'store_manager.php', 'action=update_all_products_viewed&', '192.168.0.73'),
(6689, '2007-05-24 13:59:56', 1, 'store_manager.php', '', '192.168.0.73'),
(6690, '2007-05-24 14:00:00', 1, 'store_manager.php', 'action=update_all_products_ordered&', '192.168.0.73'),
(6691, '2007-05-24 14:00:01', 1, 'store_manager.php', '', '192.168.0.73'),
(6692, '2007-05-24 15:18:06', 1, 'categories.php', '', '192.168.0.73'),
(6693, '2007-05-24 15:18:29', 1, 'categories.php', 'cPath=1&', '192.168.0.73'),
(6694, '2007-05-24 15:18:42', 1, 'categories.php', 'cPath=1_2&', '192.168.0.73'),
(6695, '2007-05-24 15:18:46', 1, 'categories.php', 'cPath=1_2_25&', '192.168.0.73'),
(6696, '2007-05-24 15:18:50', 1, 'product.php', 'page=1"uct_type=1&cPath=1_2_25&pID=17&action=new_product&', '192.168.0.73'),
(6697, '2007-05-24 15:19:12', 1, 'product.php', 'cPath=1_2_25"uct_type=1&pID=17&action=new_product_preview&page=1&', '192.168.0.73'),
(6698, '2007-05-24 15:19:13', 1, 'categories.php', 'cPath=1_2_25&', '192.168.0.73'),
(6699, '2007-05-24 15:19:18', 1, 'product.php', 'page=1"uct_type=1&cPath=1_2_25&pID=17&action=new_product&', '192.168.0.73'),
(6700, '2007-05-24 15:20:37', 1, 'product.php', 'cPath=1_2_25"uct_type=1&pID=17&action=new_product_preview&page=1&', '192.168.0.73'),
(6701, '2007-05-24 15:20:43', 1, 'product.php', 'cPath=1_2_25"uct_type=1&pID=17&action=update_product&page=1&', '192.168.0.73'),
(6702, '2007-05-24 15:20:44', 1, 'categories.php', 'cPath=1_2_25&pID=17&page=1&', '192.168.0.73'),
(6703, '2007-05-24 15:22:35', 1, 'product.php', 'page=1"uct_type=1&cPath=1_2_25&pID=17&action=new_product&', '192.168.0.73'),
(6704, '2007-05-24 15:22:36', 1, 'product.php', 'page=1"uct_type=1&cPath=1_2_25&pID=17&action=new_product_meta_tags&', '192.168.0.73'),
(6705, '2007-05-24 15:23:41', 1, 'categories.php', 'cPath=1_2_25&pID=17&page=1&', '192.168.0.73'),
(6706, '2007-05-24 15:27:56', 1, 'newsletters.php', '', '192.168.0.73'),
(6707, '2007-05-24 15:28:00', 1, 'newsletters.php', 'action=new&', '192.168.0.73');
-- --------------------------------------------------------

[Ajeh]

The Admin activity log is for review purposes if there was a problem ...

So you are safe to remake it ...

Go to phpMyAdmin and use this to drop and re-create the empty table to eliminate this error ...

DROP TABLE IF EXISTS admin_activity_log;
CREATE TABLE admin_activity_log (
  log_id int(15) NOT NULL auto_increment,
  access_date datetime NOT NULL default '0001-01-01 00:00:00',
  admin_id int(11) NOT NULL default '0',
  page_accessed varchar(80) NOT NULL default '',
  page_parameters text,
  ip_address varchar(15) NOT NULL default '',
  PRIMARY KEY  (log_id),
  KEY idx_page_accessed_zen (page_accessed),
  KEY idx_access_date_zen (access_date),
  KEY idx_ip_zen (ip_address)
) TYPE=MyISAM; 

You appear to be missing the auto_increment ...

[Ajeh]

NOTE: with prefixes such as zen_ on your table names, you need to use:

DROP TABLE IF EXISTS zen_admin_activity_log;
CREATE TABLE zen_admin_activity_log (
  log_id int(15) NOT NULL auto_increment,
  access_date datetime NOT NULL default '0001-01-01 00:00:00',
  admin_id int(11) NOT NULL default '0',
  page_accessed varchar(80) NOT NULL default '',
  page_parameters text,
  ip_address varchar(15) NOT NULL default '',
  PRIMARY KEY  (log_id),
  KEY idx_page_accessed_zen (page_accessed),
  KEY idx_access_date_zen (access_date),
  KEY idx_ip_zen (ip_address)
) TYPE=MyISAM; 

[Stuff4Toys]

Now the admin panel will not open at all.
http://www.liberty-flag.com/admin/index.php

Ajeh, I ran the query that you sent me, and I get:

Warning: Cannot modify header information - headers already sent by (output started at /web/myadmin/m50/1/libraries/header_meta_style.inc.php:27) in /web/myadmin/m50/1/libraries/common.lib.php on line 1154

Not sure what the header information is? This is what I get from the database admin: It looks complete to me, but the admin will not even open now.




JOhn ><>

[Ajeh]

I am not sure what that file is ... and I don't see your site coming up at all ...

Is that file part of an add-on?

[Stuff4Toys]

I am not sure what that file is ... and I don't see your site coming up at all ...

Is that file part of an add-on?

http://www.liberty-flag.com/admin/index.php is the address to the admin panel that is not coming up. I have changed the root index.php to a static index.htm so I can display the down for maintenance page.

The picture is the phpMyAdmin layout for the db. It shows the table layout for the admin_activity_log table. Does it look complete? Are the fields and indexes set up correctly?

[Stuff4Toys]

So I did my best to compare the admin_activity_log file to one on a functioning database and have them set up the same. The Admin Panel will still not come up.

http://www.liberty-flag.com/admin/

Just does NOT load. I compared the admin/includes/configure.php from my test site AND the /includes/configure.php and I believe all is set up correctly.

Is there somewhere else I need to check settings?

If you want to see the site with many broken image links try:
http://www.liberty-flag.com/x-index.php

Heeeeelp Pleeeaaassse
JOhn ><>

[Stuff4Toys]

THANKS Linda

Got everything working and up on the new server. Still missing a few images and descriptions, but take a look around. Please don't order anything yet. http://www.liberty-flag.com/index.php

THANKS AGAIN
JOhn ><>