Dizkus

Just upgraded and now i get this error when i enter the admin page, I also get none of the catagories / links either...

What did you upgrade from and to? Did you follow the instructions in manual.txt?

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

yeah.760 to .762

In that case, you should have used the full distribution of .762 to upgrade. Did you?

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

Yup i did. At first after i upgraded, it disabled all my 3rd party modules.
Trying to get to the admin panel i get that error. But I can get to the other pages when i directly go the the link ie index.php?module=Blocks&type=admin&func=view etc etc. Its just that dang admin panel that will refuse to load.

Raichu19, did you manage to solve this issue with categories in the Admin's admin?

I'll be glad to hear from you, as i'm having the exact same problem upgrading from 0.750 to 0.764 (full distrib) with Apache-1.3.37 / MySQL-3.23.58 / PHP-4.4.4. I can't create any category in the Admin' admin (nothing happens)...

Does Mysql > 4 absolutely necessary for 0.764, as it wasn't until 0.763?

Thanks in advance for any hint...

Bye.

Took me some time, but the download page on the main site answers your question: Source

Might be an option BTW to have it stated also that if MySQL 5.x is used, which setting is needed, since not everyone has it's own server. Just an idea.

--
Doe Maar Freak

--
regards from germany
..::[Zikula Application Framework]::.. ..::[SEO-Blog]::.. ..::[CMS Sicherheit]::..

Thanks for your reply, i just wanted to be sure this issue was related to MySQL... BTW, are you sure it is?
As everything else is working smoothly, i'm a bit reluctant with the MySQL upgrade (huge databases, not only for PN)... But if i'm 100% sure it's related, i'll do it :) .

Bye.

Apparently you're not sure ;) .

Bye.

Just a little feedback...
Well you could now be sure Larsneo, i just upgraded to MySQL-4.0.16 (couldn't go higher, old RH7.2 linux release) and apparently the problem is GONE! Admin categories and panels are back :) .
Thanks for pushing me to upgrade Larsneo, as i was VERY reluctant to do this...

Well, now i got some "Query Failed" at some places (top of the page), but that's probably another story (search function, here i come), but i really hope it's not related to a necessary 4.1 MySQL...

Bye.

I found by enabling the debugging and showing the admin page the following error.
1146: Table 'longhofer_com_-_pn.nuke_admin_category' doesn't exist

adodb_mysql._execute() % line 861, file: adodb.inc.php
adodb_mysql.execute() % line 492, file: adodb-mysql.inc.php
adodb_mysql.selectlimit() % line 392, file: pnadminapi.php
admin_adminapi_getall() % line 687, file: pnMod.php
pnmodapifunc() % line 866, file: pnadmin.php


Fatal error: mysql error: [1146: Table 'longhofer_com_-_pn.nuke_admin_category' doesn't exist] in EXECUTE("SELECT nuke_admin_category.pn_cid, nuke_admin_category.pn_name, nuke_admin_category.pn_description FROM nuke_admin_category ORDER BY nuke_admin_category.pn_name LIMIT 0,2147483647") in /home/virtual/site2/fst/var/www/html/includes/classes/adodb/adodb-errorhandler.inc.php on line 77


The way I fixed it was to recreate the table using phpMyAdmin and selecting my database then
inserting the following queries:

1.
CREATE TABLE `nuke_admin_category` (
`pn_cid` int(10) NOT NULL auto_increment,
`pn_name` varchar(32) NOT NULL default '',
`pn_description` varchar(254) NOT NULL default '',
PRIMARY KEY (`pn_cid`)

2.
LOCK TABLES `nuke_admin_category` WRITE;
INSERT INTO `nuke_admin_category` VALUES (1,'System','System Modules'),(2,'Content','Content Modules'),(3,'Resource Pack','Resource Pack Modules'),(4,'Utility','Utility Modules'),(5,'3rd Party','Third Party Modules');
UNLOCK TABLES;

Then all was good again.
BTW im running MySQL 3.23.58



edited by: MadMax, Jan 14, 2007 - 02:10 PM

I just upgraded a site from 7.5.0 to 7.6.4 and get the Error! Sorry! A problem was encountered while loading items.
I checked the MySQL server and found it was not running the right level of sorftware, contacted the web host provider, he moved teh site to a new server. The MySQL Server version is 4.1.22-standard Yet I still get the error. Any ideas? I am about to switch web host providers if this does not get fixed.
Joe............