Member
Hi!
I developed a custom theme for ZP using the instructions for a ZP/WP integrated theme found at ruzee.com. (I actually hard-coded the header in instead of calling it so that I could customize the navigation.)
The theme works just fine locally, and looks great. (PHP version 5.2.1, MySQL version 5.0.38-Ubuntu_0ubuntu1-log.) ZP installs just fine on my shared hosting server, and actually runs perfectly when I'm using any one of the included themes. But when I try to use my custom theme, ZP dies as soon as it hits the loop (`<?php while (next_album()):?>` on index.php) with the following error message:
`MySQL Query ( SELECT folder, sort_order FROM 'albums' ORDER BY sort_order ) Failed. Error: Table 'bsd_wordpress.albums' doesn't exist`
The shared hosting service is using PHP 5 (not sure of the full version) and MySQL 4.1.14
Any ideas about what I'm doing wrong? I'm kinda stumped, since it works just fine locally. `cache` and `albums` are at 0777 on the server, and as far as I know, .htaccess and zp-config.php are configured correctly. And like I said, the included themes work fine.
I should also tell you that according to phpMyAdmin, the tables [i]are[/i] there.
I developed a custom theme for ZP using the instructions for a ZP/WP integrated theme found at ruzee.com. (I actually hard-coded the header in instead of calling it so that I could customize the navigation.)
The theme works just fine locally, and looks great. (PHP version 5.2.1, MySQL version 5.0.38-Ubuntu_0ubuntu1-log.) ZP installs just fine on my shared hosting server, and actually runs perfectly when I'm using any one of the included themes. But when I try to use my custom theme, ZP dies as soon as it hits the loop (`<?php while (next_album()):?>` on index.php) with the following error message:
`MySQL Query ( SELECT folder, sort_order FROM 'albums' ORDER BY sort_order ) Failed. Error: Table 'bsd_wordpress.albums' doesn't exist`
The shared hosting service is using PHP 5 (not sure of the full version) and MySQL 4.1.14
Any ideas about what I'm doing wrong? I'm kinda stumped, since it works just fine locally. `cache` and `albums` are at 0777 on the server, and as far as I know, .htaccess and zp-config.php are configured correctly. And like I said, the included themes work fine.
I should also tell you that according to phpMyAdmin, the tables [i]are[/i] there.
Member
1) do you have a link we can look at?
2) copy your zp-config.php database portion into here so we can look at it (obvioulsy minus the username and pass).
2) copy your zp-config.php database portion into here so we can look at it (obvioulsy minus the username and pass).
Member
Here it is. It's going to be an online portfolio/blog thing.
Zp-config looks a little something like this:
`
////////////////////////////////////////////////////////////////////////////////
// Database Information (the most important part!)
////////////////////////////////////////////////////////////////////////////////
$conf['mysql_user'] = "my user info";
$conf['mysql_pass'] = "my password";
$conf['mysql_host'] = "mysql01.powweb.com"; // Won't need to change this 90% of the time.
$conf['mysql_database'] = "zenphoto_bsd";
// If you're sharing the database with other tables, use a prefix to be safe.
$conf['mysql_prefix'] = "";
`
No prefix, and it's connecting to/writing to the database just fine. I think.
Thanks!
Zp-config looks a little something like this:
`
////////////////////////////////////////////////////////////////////////////////
// Database Information (the most important part!)
////////////////////////////////////////////////////////////////////////////////
$conf['mysql_user'] = "my user info";
$conf['mysql_pass'] = "my password";
$conf['mysql_host'] = "mysql01.powweb.com"; // Won't need to change this 90% of the time.
$conf['mysql_database'] = "zenphoto_bsd";
// If you're sharing the database with other tables, use a prefix to be safe.
$conf['mysql_prefix'] = "";
`
No prefix, and it's connecting to/writing to the database just fine. I think.
Thanks!
Member
Hope this helps somebody help me...The index.php looks like this, up until the loop:
`<?php if (!defined('WEBPATH')) die(); ?>
<?php require($_SERVER['DOCUMENT_ROOT'].'/wp-blog-header.php'); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" <?php language_attributes(); ?>>
<head profile="http://gmpg.org/xfn/11">
<meta http-equiv="Content-Type" content="<?php bloginfo('html_type'); ?>; charset=<?php bloginfo('charset'); ?>" />
<title><?php bloginfo('name'); ?> <?php if ( is_single() ) { ?> » Blog Archive <?php } ?> <?php wp_title(); ?></title>
...blah blah blah meta tags
<meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8"/>
<link rel="stylesheet" href="<?php bloginfo('stylesheet_url'); ?>" type="text/css" media="screen" />
<link rel="alternate" type="application/rss+xml" title="<?php bloginfo('name'); ?> RSS Feed" href="<?php bloginfo('rss2_url'); ?>" />
<link rel="pingback" href="<?php bloginfo('pingback_url'); ?>" />
<?php zenJavascript(); ?>
<!--[if lt IE 7]><link rel="stylesheet" type="text/css" href="ie.css" /><![endif]--> <!-- IE 6 and below need help with transparent PNGs. -->
</head>
<body>
<div id="branding">
[img]<?php bloginfo('url'); ?>/img/logo.jpg[/img]
Big Sweater Graphic Design
<ul id="nav">
<li class="portfolio">Portfolio</li>
<li class="blog"><a <?php if (is_home() || is_single() || is_archive() || is_search() || is_category()) { echo 'class="active"'; } ?> href="<?php bloginfo('url') ?>/blog/" title="Blog" >Blog</a></li>
<li class="about"><a <?php if (is_page('About')) { echo 'class="active"'; } ?> href="<?php bloginfo('url') ?>/about/" title="About Big Sweater Design">About</a></li>
<li class="contact"><a <?php if (is_page('Contact')) { echo 'class="active"'; } ?> href="<?php bloginfo('url') ?>/contact/" title="Get in touch!">Contact</a></li>
</ul>
</div>
<div id="content">
<div id="columnWrap" class="wide">
<div class="col1">
<div class="columnContent">
Here are some examples of my past work.
<ul id="albums">
<?php while (next_album()):?>
<li>
<ul class="album">
<li class="imagethumb">`
You can see some of the WP conditionals there in the navigation; I also need to be able to use WP template tags/conditional statements for the sidebar and footer. The problem has to be somewhere in there, right? Since when the page is put together, it gets as far as "Here are some examples of my past work." Again, the theme works locally, and [i]every other default theme[/i] works on the shared server.
Hope that's enough info! Thanks again for any and all help.
`<?php if (!defined('WEBPATH')) die(); ?>
<?php require($_SERVER['DOCUMENT_ROOT'].'/wp-blog-header.php'); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" <?php language_attributes(); ?>>
<head profile="http://gmpg.org/xfn/11">
<meta http-equiv="Content-Type" content="<?php bloginfo('html_type'); ?>; charset=<?php bloginfo('charset'); ?>" />
<title><?php bloginfo('name'); ?> <?php if ( is_single() ) { ?> » Blog Archive <?php } ?> <?php wp_title(); ?></title>
...blah blah blah meta tags
<meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8"/>
<link rel="stylesheet" href="<?php bloginfo('stylesheet_url'); ?>" type="text/css" media="screen" />
<link rel="alternate" type="application/rss+xml" title="<?php bloginfo('name'); ?> RSS Feed" href="<?php bloginfo('rss2_url'); ?>" />
<link rel="pingback" href="<?php bloginfo('pingback_url'); ?>" />
<?php zenJavascript(); ?>
<!--[if lt IE 7]><link rel="stylesheet" type="text/css" href="ie.css" /><![endif]--> <!-- IE 6 and below need help with transparent PNGs. -->
</head>
<body>
<div id="branding">
[img]<?php bloginfo('url'); ?>/img/logo.jpg[/img]
Big Sweater Graphic Design
<ul id="nav">
<li class="portfolio">Portfolio</li>
<li class="blog"><a <?php if (is_home() || is_single() || is_archive() || is_search() || is_category()) { echo 'class="active"'; } ?> href="<?php bloginfo('url') ?>/blog/" title="Blog" >Blog</a></li>
<li class="about"><a <?php if (is_page('About')) { echo 'class="active"'; } ?> href="<?php bloginfo('url') ?>/about/" title="About Big Sweater Design">About</a></li>
<li class="contact"><a <?php if (is_page('Contact')) { echo 'class="active"'; } ?> href="<?php bloginfo('url') ?>/contact/" title="Get in touch!">Contact</a></li>
</ul>
</div>
<div id="content">
<div id="columnWrap" class="wide">
<div class="col1">
<div class="columnContent">
Here are some examples of my past work.
<ul id="albums">
<?php while (next_album()):?>
<li>
<ul class="album">
<li class="imagethumb">`
You can see some of the WP conditionals there in the navigation; I also need to be able to use WP template tags/conditional statements for the sidebar and footer. The problem has to be somewhere in there, right? Since when the page is put together, it gets as far as "Here are some examples of my past work." Again, the theme works locally, and [i]every other default theme[/i] works on the shared server.
Hope that's enough info! Thanks again for any and all help.
Member
This setup doesnt seem to follow the setup on ruzee.com
The reason it is not working is because it is looking at the incorrect database. it is looking at your wordpress database for the zenphoto pictures (bsd_wordpress.albums as opposed to zenphoto_bsd.albums as specified in your zp-config)
There is nothing in your index that specified to connect to the zenphoto database. You said you hardcoded the header for your navigation but after the wp header you need the db_connect() to connect to the zenphoto database then after the zp loops you need to add back in the $wpdb->select(DB_NAME); // reconnect wordpress db.
I hope this maybe sheds a little light on your problem
The reason it is not working is because it is looking at the incorrect database. it is looking at your wordpress database for the zenphoto pictures (bsd_wordpress.albums as opposed to zenphoto_bsd.albums as specified in your zp-config)
There is nothing in your index that specified to connect to the zenphoto database. You said you hardcoded the header for your navigation but after the wp header you need the db_connect() to connect to the zenphoto database then after the zp loops you need to add back in the $wpdb->select(DB_NAME); // reconnect wordpress db.
I hope this maybe sheds a little light on your problem
Member
Craps. You're exactly right. I had been using the same DB as the WP one on my local server instead of creating a new one for ZP.
Told it to hook up to the ZP database and it works like a charm now. Thanks chili! I needed some outside eyes to catch such a dumb mistake.
Told it to hook up to the ZP database and it works like a charm now. Thanks chili! I needed some outside eyes to catch such a dumb mistake.