New Day / New Problem - DB errors

[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 ><>