Welcome, Guest
Please Login or Register.    Lost Password?

Installation: "DB function failed"
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Installation: "DB function failed"
#2
Installation: "DB function failed" 1 Year, 2 Months ago Karma: 0
Hello,
Great components... I love it!

I have now installed the component and I have this error:

DB function failed with error number 1146
Table '****.***_photoblog_categories' doesn't exist SQL=SELECT ordering AS value, title AS text FROM ***_photoblog_categories WHERE published > 0 ORDER BY ordering
Warning: Invalid argument supplied for foreach() in ****/libraries/joomla/html/html/select.php on line 68

Database Version: 5.0.81-community-log
Database Collation: utf8_general_ci
PHP Version: 5.2.10
Web Server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.10 mod_perl/2.0.4 Perl/v5.8.8
Web Server to PHP interface: apache2handler
Joomla! Version: Joomla! 1.5.11 Production/Stable [ Vea ] 03-June-2009 03:30 GMT

Any help?
bloggita
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Gender: Male GT-Blog Location: Italy
The administrator has disabled public write access.
 
#3
Re: Installation: "DB function failed" 1 Year, 2 Months ago Karma: 2
Hey bloggita,

when do you get this error exactly?
I can't rebuilt it on my test system...

Have you installed the correct package of the component? alpha 3a full? Or have you done any upgrade?

Best regards
Marco
Marco
Senior Boarder
Posts: 59
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4
Re: Installation: "DB function failed" 1 Year, 2 Months ago Karma: 0
Hi Marco,
I have installed the component alpha 3a full and if I go in components-->photoblog-->Category Management-->New , I find this error.

Thanks for your help.
bloggita
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Gender: Male GT-Blog Location: Italy
The administrator has disabled public write access.
 
#5
Re: Installation: "DB function failed" 1 Year, 2 Months ago Karma: 2
Have you installed an older photoblog version before?
Or could you check the database tables over phpmyadmin, if the table exists? If it exists, it must have the following fields:
id, title, label, folder, description, metadesc, metakey, parent, ordering, published, order, created and modified...
Marco
Senior Boarder
Posts: 59
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6
Re:Installation: "DB function failed" 1 Year, 2 Months ago Karma: 0
Solved...

I checked my database.
The component install automatically the tables with the prefix "jos_" but I use a different prefix.
I changed the code and now everything works fine.

Great!

Thanks Marco!
bloggita
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Gender: Male GT-Blog Location: Italy
The administrator has disabled public write access.
 
#7
Re:Installation: "DB function failed" 1 Year, 2 Months ago Karma: 2
okay, nice
I will fix this issue in the next version!

Note: the bug is now fixed in the current packages...
Marco
Senior Boarder
Posts: 59
graph
User Offline Click here to see the profile of this user
Last Edit: 2009/06/30 18:38 By Marco.
The administrator has disabled public write access.
 
Go to topPage: 1