[Mod] Category order / Kategorien ordnen

[lovetamil]

i am gettin this error..when i update my database...please advice...

Code: [Select]

DB Error: Bad SQL Query: INSERT INTO 4imagesga_settings (`setting_name`, `setting_value`) VALUES ('cat_order', 'c.cat_name ASC')
Duplicate entry 'cat_order' for key 1

[Lunique]

I've Installed the mod and it worked fine thanks for it!
But I have a question about something Vano allready asked. Is there any way that it ALSO affect category sort in "admin control panel -> edit categories"
Would be great cause that's what I really need!

Habe den Mod installiert und funktioniert alles prima. Vielen Dank dafür!
Aber ne Frage zu dem was Vano schon fragte. Ist es möglich das man das ganze AUCH BEIM "admin control panel -> Kategorien bearbeiten" nutzen kann?
Denn sowas such ich dringend!

[salimiali]

After go to gallery show this message with any pictures and categories!!


DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_name ASC
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.image_active = 1) GROUP BY c.cat_id O


Link: http://www.singersfan.com/gallery/

[salimiali]

admin help me please! my web site is down and i can not run this mode please help me how i can run this
mode because now my data base have problem!! (after setup mysql installer) if you can run this mode tell
me i send to you my user & password of ftp


DB Error: Bad SQL Query: SELECT cat_id, cat_name, cat_description, cat_parent_id, cat_hits, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment FROM 4images_categories ORDER BY c.cat_name ASC
Unknown table 'c' in order clause

[niad]

Hello,
I have read this post very carefully more than 10 times and also some other post with the same subject and I have done everything exactly as I should.
The problem is that the sorting  doesn't work with my language.
I have the correct $lang['charset'] = at the main.php of my language, but doesn't sort the categories.
Everything are working fine,  the sorting options at the Admins settings are there, but there is no correct sorting!
It does some kind of sorting, but it puts first B and then A for example!

Is there any way that this MOD can work with a foreign languages?

PLEASE, I need some help

.

[V@no]

I think its not about this mod, its about how your MySQL handles sorting...what about images? can you sort them by name?

[niad]

Dear V@no, no, the images can't be sorted by name correctly also!



Please help, there must be an answer to solve this problem!

.

[niad]

.

Is there any way that this MOD can work with a foreign languages?

PLEASE, can someone help ?

.

[V@no]

I have answered your question already, its not this mod's problem, in fact its not 4images problem, its MySQL problem...if MySQL can't sort it properly nothing you can do about it...

[niad]

.
Thank you very much for your answer V@no,
I have understand what you have said,
I was just hoping that you or someone else may have some answer to this MySQL problem of sorting...
Where can I check or what can I add to MySQL settings to solve the sorting problem?
.

[fgallery]

INSERT INTO `4images_settings` ( `setting_name` , `setting_value` )
VALUES (
'cat_order', 'cat_name ASC'
);

Thanks for the hint DaMike !

V@no I think you should specify that your installer is for 1.7 vesion.

[djith]

hello,
i tried this mod and at the last line there was something whit phpmyadmin, where can i find it and how to use it and install the last line....?

[Acidgod]

please read the bold text below...

===============================================================
== SQL (add this with phpmyadmin or run this installer --> installer (thx V@no for this installer)
===============================================================

[djith]

yes i read , but i'm such a newbie that i don't know where to find phpmyadmin, what to do with, how to run an installer ....
do i have to look for phpmyadmin in the control panel of my server ?

[Acidgod]

please read the bold text below...

===============================================================
== SQL (add this with phpmyadmin or run this installer --> installer (thx V@no for this installer)
===============================================================

You dont need to make any changes with phpmyadmin, please use the installer!
Download the *.zip File, put it in your 4images root folder and then use your Browser to execute the Installer