Wordpress On ZC [Support Thread]

[misty]

PM Received from Stenrique regarding his post above..
My response, which may help other members, is as follows:-
Do you have database link correctly configured in sideboxes i.e. archive side box..

  $content = '<ul>'.zen_wp_get_archives('type=monthly').'</ul>';

Above is configuration from my own install which reflects database table for wordpress install as zen_wp
Tips...
WordPress install integrated into zencart slows down
cart performance considerably..
my install was wordpress mod release before current offering
..sideboxes..I reverted to rss sidebox/es instead..
see demo, leftside bottom box, at
http://www.mistily.com/zendemo/index.php

[magicpants]

I've gone through this thread at least 3 times and read the others about Wordpress -- at some point, I think I saw the answer to my problem but now I can't find it.

I have zen cart installed in a directory (catalog) -- my REAL live shop is in the root, but this is my test shop where I want to set up wordpress first. The wordpress files are installed in the "root" of the test shop (in the catalog directory). Isn't there a way to make this work?

It mostly works, I see the wordpress page with menu on the right, the sideboxes are showing up fine. Everything except no posts or pages ever show up. I click on a page and it just doesn't show -- all that I see is "Edit this post" at the top. Or sometimes it says "Not Found". I'm guessing this is because I'm in a directory?

Third day on this -- would really appreciate some help! I'd hate to have to install this in my live shop to test and set up.

[misty]

Third day on this -- would really appreciate some help! I'd hate to have to install this in my live shop to test and set up.

WordPress Module Files are currently at
http://www.s-page.net/products/62.html
magicpants..which version have you installed i.e.
1.2 or 1.3? Makes BIG difference because version 1.2
would only install correctly into zencart using actual
domain..i.e your domain.com and not yourdomain.com/cart

[magicpants]

We're using 1.3.6.

So, you're saying this should be working correctly? If so, then what should I look into to solve this weirdness with posts/pages not showing at all?

[misty]

We're using 1.3.6.

So, you're saying this should be working correctly? If so, then what should I look into to solve this weirdness with posts/pages not showing at all?

Yes, ok you are using ZenCart v1.36 BUT I asked
which version of WordPress module did you install..
Version 1.2 or Version 1.3
from http://www.s-page.net/products/62.html

[magicpants]

Ah sorry -- zen wordpress mod is 1.3 even though the readme says 1.2. I downloaded it again and doublechecked. We're using the latest wordpress files: 2.1.3.

[misty]

Thanks for info visited your site from url in PM you sent..
Your zencart with wordpress module installed should look
like http://www.dezinacart.co.uk/index.ph...page=wordpress
so did you read wordpress module instructions regarding adding
css to your existing template stylesheet and adding a revised
template page i.e.

----------------
Design adjustment
----------------
1.Please revise a header of a Wordpress theme, a footer, a sidebar, a style sheet.
(Please just upload a reference file if troublesome.)
Reference [/SAMPLE/wp-content/themes/]
2.Please add the following to a style sheet of ZenCart.
/* bigin */
.leftboxcontent ul li, .rightboxcontent ul li , .singleboxcontent ul li{
list-style-type: none;
margin:0px;
padding-left: 0px;
}
.leftboxcontent ul, .rightboxcontent ul , .singleboxcontent ul{
margin:0px;
padding-left:0px;
}
.leftboxcontent ul ul, .rightboxcontent ul ul, .singleboxcontent ul ul{
list-style-type: square;
margin:0px;
padding-left:5px;
}
/* end */

zencart Sideboxes for wordpress MUST reflect correct mysql setting for
your wordpress install..and wordpress sql database
should be in same database as zencart install..
See my earlier reply today, this thread(postnumber 98), in answer to Stenrique's similar post..

[Stenrique]

I found that the missing lower portion of the sidebox is due to the missing 'div' element in the sidebox code.

However, I am still encountering the error:

Warning: mysql_error(): 10 is not a valid MySQL-Link resource in /home/mysite/public_html/blog/wp-includes/wp-db.php on line 177

Could you elaborate on the following?

Do you have database link correctly configured in sideboxes i.e. archive side box..

  $content = '<ul>'.zen_wp_get_archives('type=monthly').'</ul>';

Above is configuration from my own install which reflects database table for wordpress install as zen_wp

TIA.

[misty]

I found that the missing lower portion of the sidebox is due to the missing 'div' element in the sidebox code.

However, I am still encountering the error:
Could you elaborate on the following?
TIA.

Is your WordPress Module installed in same SQL database as your zencart install?
Can you post sql details? do entries start as
zen_wp_

Have just installed WordPress Module(latest 1.3 Version)
into Demo ZenCart 1.37 showcase site
at http://dezinashop.com/demo/

As you will see, sideboxes work fine, as does 3 latest blog
posts integrated into zencart main index page..
WordPress mod files uploaded directly into zencart folder....

[Stenrique]

For some reason, I'm getting a "Server not found" error when I click on the link to the demo site.

Is your WordPress Module installed in same SQL database as your zencart install?

Yes, wordpress tables are installed in the same database as those of zencart tables.

Can you post sql details? do entries start as
zen_wp_

Mind elaborating on the above? Brain's at 1st gear now. If I understand you correctly, all my Wordpress tables are prefixed with "mysite_wp_".

My zencart is still at version 1.36 and Wordpress is installed in a sub-folder named "blog" under my catalogue (home/mysite/public_html/blog). TIA.