Pages (2): 1 2   
Unregistered
Unregistered
Guest   Less than 1 minute ago
#1

how can I fix this?

Zenphoto Error
MySQL Query ( SELECT id, cat_name, cat_link, hitcounter, permalink FROM zp_zenpage_news_categories ORDER by cat_name ) failed. Error: Table 'ziziland_test.zp_zenpage_news_categories' doesn't exist

Administrator
Administrator
acrylian   2009-06-15, 18:20
#2

Run setup.php

Member
Member
huzsef   2009-06-16, 18:44
#3

I have the same problem, I try'd to fix it with setup.php without success.
Have You an other idea? (ZenPhoto 1.2.5)

Administrator
Administrator
acrylian   2009-06-16, 18:54
#4

Setup will create the missing db tables. If it not does that something else will be wrong. What does setup tell you, any error? MAybe errors in your cgi log?

Member
Member
huzsef   2009-06-16, 21:06
#5

Thank You for the answer, no warnings during the setup and no error messages after the setup.

Member
Member
sbillard   2009-06-16, 22:12
#6

Just to be sure we are clear. First enable the zenpage plugin. Then (with it enabled) run setup.php.

Member
Member
huzsef   2009-06-17, 14:19
#7

Thank's now I am clear... It works... Thank's again.

Junior Member
Junior Member
eiffel   2009-06-18, 16:19
#8

Hi - this is my very first time using Zenphoto and Zenpage and am having trouble with the above mysql error.

I have enabled Zenpage from within Zenphoto and am using Zenpage-Default as my theme.

I've tried going to mydomain.com/zp-core/plugins/zenpage/setup.php but that file doesn't exist.

I've tried downloading various tarballs and zip versions of Zenphoto and none of them contain this file. What am I missing here?

EDIT: looks like i was missing running mydomain.com/zp-core/setup.php again - which i stumbled upon as it wasn't mentioned anywhere

Administrator
Administrator
acrylian   2009-06-18, 16:24
#9

You need to run the main setup file under zp-core/setup.php. (the first separatly release Zenpage versions before Zenphoto 1.2.4 indeed had their own setup).

Administrator
Administrator
acrylian   2009-06-18, 16:27
#10

Actually setup should run again automatically after enabling Zenpage but that somehow got lost in 1.2.5. Will be back in the next version.

Junior Member
Junior Member
slriley   2009-07-23, 10:15
#11

How do I run the setup.php installed on my web host's system?

I cannot even log in as and admin. Right now, it's completely dead.

MySQL Query ( SELECT id, cat_name, cat_link, hitcounter, permalink FROM zp_zenpage_news_categories ORDER by cat_name ) failed. Error: Table 'valaddso_znp01.zp_zenpage_news_categories' doesn't exist

Administrator
Administrator
acrylian   2009-07-23, 11:44
#12

As said two posts above www.yourdomain.com/zenphoto/zp-core/setup.php (if Zenphoto is installed within the folder "zenphoto" o course!).

Member
Member
castortroy2009   2009-07-30, 17:41
#13

This is the third thing I found that newbies need to know. I almost dumped this amazing software because of all the errors I was getting. I think I will be contributing by making a newbies startup topic for people with limited or no server/mysql/php skills.

Administrator
Administrator
acrylian   2009-07-30, 18:25
#14

This one is actually a bug that will be corrected in 1.2.6. Generally the setup errors are labeled as a "warning" and with some description to give a hint. And you can always ask on the forum. Sometimes a quick web search also helps..:-). There are better places for general server/mysql/php skills.

But if you want to contribute on some documentation that will be welcome.

Member
Member
castortroy2009   2009-07-31, 02:32
#15

The problem with many newbies like me is asking the right question, so it takes a little research first. I appreciate your work on this great software solution. I did some vtc php tutorials and I (eventually) figured out how yum works to check/install/update php-gd which was not in my centos5 install but I still get the following error when I click on something:

The requested URL /testfile/ was not found on this server.

Figuring this stuff out is like when you buy a car, the seller assumes you know how to drive so they leave out very basic things like "put the key in the ignition". As someone who has no problems with shared hosting servers with the plesk control panel, getting into VPS servers to be able to do things with root access like Flash Media Server and zenphoto as a standalone serverside app is very cool but also challenging.

-GC

http://arktosarchive.com

Administrator
Administrator
acrylian   2009-07-31, 07:52
#16

I absolutly understand your point, but we really can't "teach" every detail about these things. If someone tries to install a application on a server we just assume he either knows how to or is willing to learn a few things himself. Or alternatively he knows someone who does.

Member
Member
castortroy2009   2009-07-31, 10:51
#17

Thank you for your response and I see your point as well. I think this is where I can help as I am at the almost newbie level. I think I could be of help to get more people using this. In my attempts at learning how all this stuff works (linux commands, yum, php, FMS,mysql,virtual private servers, etc) I see that its not that hard and very exciting to see 'behind the curtain'.

I look forward to contributing.

-GC

Administrator
Administrator
acrylian   2009-07-31, 13:13
#18

I see you already started. Very welcome. You alternatively could also create an account on our Trac wiki (bugtracker) and work there on a "newbie tutorial" page. That might be a little more convenient to work with than the forum.

Member
Member
castortroy2009   2009-08-01, 02:09
#19

Got it!

Member
Member
castortroy2009   2009-08-01, 02:19
#20

mod rewrite was the enemy. When I disabled it in zenphoto admin page - options - general it works (with photos- now trying video- HOORAY!

Pages (2): 1 2   
  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.