![]() |
|
Trouble installing, MySQL Query Failed - Printable Version +- ZenphotoCMS Forum (https://forum.zenphoto.org) +-- Forum: Support (https://forum.zenphoto.org/forum-1.html) +--- Forum: General support (https://forum.zenphoto.org/forum-4.html) +--- Thread: Trouble installing, MySQL Query Failed (/thread-1937.html) Pages:
1
2
|
Trouble installing, MySQL Query Failed - kristofferb - 14-12-2007 Hello. Have tried to install zenphoto, but get this error message: Quote:[b]Zenphoto Error[/b] MySQL Query ( SELECT Quote:No input file specified. Trouble installing, MySQL Query Failed - trisweb - 14-12-2007 Looks like you're missing the setup.php file... try re-installing fresh from the package. Also, you may want to try the 1.1.3 release that is due out Sunday. It has much improved setup. Trouble installing, MySQL Query Failed - kristofferb - 15-12-2007 Sorry, can's say it worked. The setup.php-file is in the zp-core-folder. If I should take a wild guess, it looks like the database don't accept/import the tables. I have no knowledge about this, so i can't say for sure. I'll wait for the 1.1.3-release and try then. Trouble installing, MySQL Query Failed - trisweb - 15-12-2007 What's the address of your installation? We can help you easier if we can look at it. Thanks. Or, yes, just wait for 1.1.3 Trouble installing, MySQL Query Failed - kristofferb - 19-12-2007 The adress is http://medkom.org/zenphoto/ Will try the 1.1.3-version, priority others above me. At least to the next time I'll need help. Edit: Damn, won't work with the 1.1.3 version. Seems to be the same. Is there a way to check if my DB information is correct? Edit2: Okay, I managed to install bbpress, so it shouldn't be anything wrong with the database information. But, if it helps, the configure file: This gallery lays here: http://utvikling.altarussen.org/zen/ Trouble installing, MySQL Query Failed - sbillard - 19-12-2007 Are you still getting the same error message? If not, what is the message this time? Setup should have given you a checklist report. I assume it said everything was ok. Trouble installing, MySQL Query Failed - sbillard - 19-12-2007 You have provided two urls. The first ( http://medkom.org/zenphoto/ ) gives me the zenphoto error that is an indication that the setup program has not been run. The second ( http://utvikling.altarussen.org/zen/ ) takes me to a logon screen. Which is the correct one? On the first site I tried to run setup for you, however I got a page not found error indicating that setup.php is missing from the install. Have you run setup.php? Trouble installing, MySQL Query Failed - Daxeno - 20-12-2007 kristofferb, that same thing happened to me since i have re-installed it to version 1.1.3, dunno why. im still trying to figure it out but it aint working. i have fresh intalled everything and it wont work at all. Trouble installing, MySQL Query Failed - trisweb - 20-12-2007 Daxeno, what's your site's address? Are you also getting the error with setup.php not being found, or just the Options table mysql error? kristofferb, For some reason on the medkom.org site the Setup.php file cannot be found. This is the main problem, but I don't know what's causing it -- the "No input file specified" error is not from Zenphoto. I just thought of something --- what are the permissions set on your zp-core .php files? They should be set such that the server process can read them, so try chmodd'ing at least But -- the main (and only) problem is that the server (specifically the PHP CGI process) can't read the PHP files. It's a server config problem, but we'll try to help you solve it... Trouble installing, MySQL Query Failed - Daxeno - 20-12-2007 Hello Tris! Here's my site address > http://daxeno.craserv.com/zenphoto/ hope you could figure it out. The webpage cannot be found This error (HTTP 404 Not Found) means that Internet Explorer was able to connect to the website, but the page you wanted was not found. It's possible that the webpage is temporarily unavailable. Alternatively, the website might have changed or removed the webpage. and on the FF, it says No input file specified. Dunno whats wrong.... all files have been uploaded successfully. This only happened since i have changed to 1.1.3. Trouble installing, MySQL Query Failed - sbillard - 20-12-2007 Is there any possibility you guys did not notice the change from the php folder's old name of Trouble installing, MySQL Query Failed - trisweb - 20-12-2007 Daxeno, I want you also to check the permissions on all those files, make sure the server can read them. I don't see why not though... this is very odd... Stephen it's definitely happening in zp-core. It also doesn't work with rss.php It could be a mod_rewrite bug: Try this out: daxeno/kristofferb -- Try removing the .htaccess file. I want to see what that does... Trouble installing, MySQL Query Failed - kristofferb - 21-12-2007 Removing the .htaccess file helped (see http://utvikling.altarussen.org/zen/ user/password: dev/dev) getting up the setting page. Thank you all for the help. But why is there so few repports on this? Trouble installing, MySQL Query Failed - sbillard - 21-12-2007 could you post what was in your .htaccess file? Trouble installing, MySQL Query Failed - Daxeno - 21-12-2007 Tris, all files CHMOD's correct and the servers reading it. "Zenphoto Error i removed the .htaccess and now it is working. so it might be the htaccess file. htaccess file for zenphotoNOTE: Change the RewriteBase below to the absolute path to your zenphoto directory.RewriteEngine On !!! Change this to the web path (eg: http://www.yourwebsite.com/photos --> /photos) !!!RewriteBase /zenphoto RewriteRule ^admin/?$ zp-core/admin.php [R,L] RewriteCond %{REQUEST_FILENAME} -f [NC,OR] RewriteRule index.php$ index.php [L,QSA] Rewrite rule addtion for seachRewriteRule ^page/([A-Za-z0-9-]+)/([A-Za-z0-9-]+)/?$ index.php?p=$1&words=$2 [L,QSA] Rewrite rule addtion for archive-/date-search (needed to be separarted because of the same structur)RewriteRule ^page/([A-Za-z0-9-]+)/archive/([A-Za-z0-9-]+)/?$ index.php?p=$1&date=$2 [L,QSA] RewriteRule ^(.)/image/(thumb|[0-9]{1,4})/([^/\]+)$ zp-core/i.php?a=$1&i=$3&s=$2 [L,QSA] Catch-all - everything else gets handled in PHP for compatibility.RewriteRule ^(.*)/?$ index.php?album=$1 [L,QSA] Trouble installing, MySQL Query Failed - trisweb - 21-12-2007 Daxeno, it seems to be a bug in the mod_rewrite configuration, so try deleting or renaming your .htaccess file to fix it. Then you should be able to run setup. This seems to be a problem specific to servers running PHP as a CGI process, which isn't the most common setup but exists nonetheless (and can be better in some cases). Our .htaccess file seems to be messing with that.. I'll try setting up a PHP-CGI and test it out. Until then, if you're seeing this problem unfortunately you'll have to disable .htaccess for now while we get it figured out. (Stephen: I wonder what changed since 1.1.2?) Trouble installing, MySQL Query Failed - sbillard - 22-12-2007 trisweb: There were additions for the search rules that malte put in. Basically line 12 RewriteRule ^page/([A-Za-z0-9-]+)/([A-Za-z0-9-]+)/?$ index.php?p=$1&words=$2 [L,QSA] RewriteRule ^page/([A-Za-z0-9-]+)/([A-Za-z0-9-]+)/([0-9]+)/?$ index.php?p=$1&words=$2&page=$3 [L,QSA] Rewrite rule addtion for archive-/date-search (needed to be separarted because of the same structur)RewriteRule ^page/([A-Za-z0-9-]+)/archive/([A-Za-z0-9-]+)/?$ index.php?p=$1&date=$2 [L,QSA] RewriteRule ^page/([A-Za-z0-9-]+)/archive/([A-Za-z0-9-]+)/([0-9]+)/?$ index.php?p=$1&date=$2&page=$3 [L,QSA]` Trouble installing, MySQL Query Failed - Daxeno - 22-12-2007 Tris, it worked now but disabling the .htaccess and deleting it had affected my site - i cannot access the fils or photos if i enable the mod rewrite. Trouble installing, MySQL Query Failed - sbillard - 22-12-2007 Yes, without an .htaccess file you cannot use mod_rewrite. Sorry about that. Trouble installing, MySQL Query Failed - Daxeno - 23-12-2007 is there any way we can have this fixed? coz i cannot access some of my photos. |