PDA

View Full Version : not pulling categories from DB


weeezl
12-14-2004, 07:53 PM
I just installed pixelpost for the first time the install went fine, But even though I can see the categories information in the DB pixelpost isn't displaying it. all of the options info is pulled from the DB just fine so it isn't in the DB connect.

I am also getting some php errors in the apache logs related to "Undefined index" and "Undefined variable".

As far as I know the only thing that I don't have up to par on my server is EXIF but from what I understand is an optional thing.

PHP-version 5.0.2

MySQL version 3.23.49-log

GD-lib 2.0 or higher

Server software Apache/1.3.31 (Unix) PHP/5.0.2 FrontPage/5.0.2.2510 mod_ssl/2.8.18 OpenSSL/0.9.6e

EXIF Your php does not seem to be compiled with exif-enabled.

Any help would be greatly appreciated.

pixelpunk
12-14-2004, 08:30 PM
The errors in your log you can disregard. A puritan would've have ruled these things out and I might do that one day when I'm not lazy :)

But all around, they errors are of the kind called "notices", nothing that will affect anything really.

The categories though.
Can you post a dump of that table?

// punk

weeezl
12-15-2004, 05:33 PM
below is the dump of the pixelpost_categories table


#
# Table structure for table `pixelpost_categories`
#

CREATE TABLE `pixelpost_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `pixelpost_categories`
#

INSERT INTO `pixelpost_categories` VALUES (1, 'default');


from what I can tell the data is in there but it just doesn't display it.

weeezl
12-17-2004, 08:31 PM
I found my problem!!!!

it appears that the utf8_encode() and utf8_decode() functions were the problem. after commenting just those functions out everything works fine.

any clue to as why this would make such a huge differance?

weeezl.

Connie
12-18-2004, 07:53 AM
Hi, weezl,

I am not such a big specialist but I am sure the reason is how the php at your machine is configurated

does it support UTF?

check it out with a test.php

<?
phpinfo();
?>

weeezl
12-18-2004, 11:24 AM
Thanks Connie,

here are the configure settings for the php compile


'./configure' '--with-mysql=/usr/local/mysql' '--disable-xml' '--with-gd=/usr/local' '-with-jpeg-dir=/usr/local/include' '-with-png-dir=/usr/local/include/libpng' '--with-apache=../apache_1.3.31' '--disable-simplexml' '--disable-libxml' '--with-zlib' '--without-iconv' '--disable-pear' '--with-curl'


Just guessing but I think it may have something to do with the fact that XML is disabled. Not really sure why it was disabled but I may have to look into having this changed.

Thanks again Connie


Weeezl.