View Full Version : not pulling categories from DB
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.
MySQL version 3.23.49-log
GD-lib 2.0 or higher
Server software Apache/1.3.31 (Unix) PHP/5.0.2 FrontPage/188.8.131.520 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.
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?
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.
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?
12-18-2004, 07:53 AM
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
12-18-2004, 11:24 AM
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
vBulletin® v3.7.3, Copyright ©2000-2013, Jelsoft Enterprises Ltd.