Table 344 sql error vote

[Xcantion]

Hello everybody!!!

I have a little Problem...
I have installed Phoca 2.5 alfa... everything works but one error...

if i go in the backend to the menü point
Image Rating i become following sql error

Code: Select all

mysql.php on line 344

i have read few topics.. and i have found a fix with the tables...
https://www.phoca.cz/documents/17-phoca- ... em-solving

all tables are online and up to date..
that have fix all sql errors with the images and categories... but the vote errors are still present ...
i have following tables in my database...

jos_phocagallery
jos_phocagallery_categories
jos_phocagallery_comments
jos_phocagallery_img_votes
jos_phocagallery_img_votes_statistics
jos_phocagallery_user_category
jos_phocagallery_votes
jos_phocagallery_votes_statistics

did i miss a table?
i had use the table code from install.bak with the table prefix jos_ not #__ <- i have use right underscores... 1 instead 2
that means all table are ready for use and up to date but something seems missing!!!

[Xcantion]

Ok for now i have test a lot of thinks... it seems nearly everything works but the image rating doesnt work in front end
and in the backend the image are still present...

[Xcantion]

wow a lot of answers...

[Xcantion]

you can fix a lot of errors with this post
https://www.phoca.cz/documents/17-phoca- ... em-solving

but my errors are still present... only image vote problem

[MaXuS]

I've checked that post and also that helps a lot, but still the Image Rating issue is there.

[Xcantion]

@ MaXus

I've checked that post and also that helps a lot, but still the Image Rating issue is there.

Watch this

you can fix a lot of errors with this post
https://www.phoca.cz/documents/17-phoca- ... em-solving

but my errors are still present... only image vote problem

i Have already told someone .. you can fix a lot of errors but .. the image rating / image voting issue will be there... i think theres a problem with the tables ... or with the php code... image rating function doesnt connect to the database or ... it will use wrong datas... thats why the image rating issue is there...

[MaXuS]

Let's hope Jan can help us

[Jan]

Hi, as this error is appearing in mysql file (joomla framework), I need to know where exactly you get this error.

Please let me know step by step your action which links to this error. (screenshot will be good)

Jan

[Xcantion]

ok step by step..

download phoca gallery
install phoca gallery
go to config of phoca gallery.. -> a lot of 344 sql error...

go to phoca.cz website... search board -> found fix ...

https://www.phoca.cz/documents/17-phoca- ... em-solving

test fix ... -> create tables... (all)

test phoca gallery..
-create categorie...
-create pics...
test gallery everything works i can see pics...

ok now make the config ... -> use image rating = true -> save
frontend -> image rate test... ups... problem nothing works...

backend navigate to the menu point "image rating"
first line ...
mysql.php on line 344

ok no problem... looking in database -> hmm all tables there... everything is right...

thats all...

All tables are there... everything works... bt only image rating doesnt work...
and you can see (step by step) all tables were created.. (because you can upload pics / create categories without sql error )and all other thinks work too... in my first post you cann see all my tables in the database... it seems everything is right... i dont need a pic beause there is only the error message in the backend ... mysql.php on line 344 ... and nothing more..
in the frontend you can see the image stars but you cant rate the pic... because no connection to database ... that means 0/0 votes all the time...
no blank page
no "more" error messages
nothing... only this one line... -> no connection to database.. and ONLY with image rating...

[MaXuS]

Any update about this Jan?