|
roberto
|
 |
« on: November 01, 2006, 05:11:09 pm » |
|
sorry... I do not speak English I have acquired and installed galleryPRO, but when click Button "Approve Images" Error Unknown column 'p.USER_ID_CAT' in 'on clause' File: /web/htdocs/www.MYSITE.it/home/forum/Sources/Load.php(1707) : eval()'d code Linea: 1575 help.. aiuto  Roby |
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #1 on: November 01, 2006, 05:28:20 pm » |
|
Hmm, Seems like it did not install the queries. How did you install the gallery mod? Though the package manager?
If you need install help I can install it for you.
|
|
|
|
« Last Edit: November 01, 2006, 05:31:41 pm by SMFHacks »
|
Logged
|
|
|
|
|
roberto
|
|
« Reply #2 on: November 01, 2006, 05:34:48 pm » |
|
Admin --> Packages --> Download New Packages --> Package to Upload:
I have installed also on new SMF. without other MOD.. but
Database Error
Unknown column 'p.USER_ID_CAT' in 'on clause'
File: /web/htdocs/www.MYSTE.it/home/community/Sources/Load.php(1702) : eval()'d code
Line: 1575
help..
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #3 on: November 01, 2006, 05:37:08 pm » |
|
This is when you click "Approve Images" the text link?
|
|
|
|
|
Logged
|
|
|
|
|
roberto
|
|
« Reply #4 on: November 01, 2006, 05:38:49 pm » |
|
yes
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #5 on: November 01, 2006, 05:41:07 pm » |
|
Copy the attached file Gallery.template.php and copy to your themes/default folder.
|
|
|
|
« Last Edit: November 01, 2006, 05:58:08 pm by SMFHacks »
|
Logged
|
|
|
|
|
roberto
|
|
« Reply #6 on: November 01, 2006, 05:49:26 pm » |
|
no... non work Unknown column 'p.USER_ID_CAT' in 'on clause' File: /web/htdocs/www.inarte.it/home/forum/Sources/Load.php(1707) : eval()'d code Linea: 1506  |
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #7 on: November 01, 2006, 05:51:58 pm » |
|
Hmm can you run this mysql query via phpmyadmin ALTER TABLE smf_gallery_pic ADD `USER_ID_CAT` int(10) NOT NULL default '0'
|
|
|
|
|
Logged
|
|
|
|
|
roberto
|
|
« Reply #8 on: November 01, 2006, 05:53:35 pm » |
|
Error
query SQL:
ALTER TABLE smf_gallery_pic ADD `USER_ID_CAT` int( 10 ) NOT NULL default '0'
Messaggio di MySQL: Documentazione
#1060 - Duplicate column name 'USER_ID_CAT'
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #9 on: November 01, 2006, 05:57:30 pm » |
|
good that means it is installed in there. Try running this query in phpmyadmin REPLACE INTO smf_settings
(variable, value)
VALUES ('disableTemplateEval', '1');
Then goto the approve images page and tell me what Linea the error is on and the filename |
|
|
|
« Last Edit: November 01, 2006, 06:00:50 pm by SMFHacks »
|
Logged
|
|
|
|
|
roberto
|
|
« Reply #10 on: November 01, 2006, 06:03:57 pm » |
|
Unknown column 'p.USER_ID_CAT' in 'on clause'
File: /web/htdocs/www.SITE.it/home/community/Themes/default/Gallery.template.php
Line: 1506
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #11 on: November 01, 2006, 06:06:42 pm » |
|
Hmm, Try this file I removed the on for USER_ID_CAT copy it your themes folder
|
|
|
|
|
Logged
|
|
|
|
|
roberto
|
|
« Reply #12 on: November 01, 2006, 06:15:38 pm » |
|
No...
Unknown column 'p.ID_CAT' in 'on clause'
File: /web/htdocs/www.SITEit/home/community/Themes/default/Gallery.template.php
Line: 1507
I try to install the galleryPRO in an other server for test?
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #13 on: November 01, 2006, 06:19:22 pm » |
|
That's fine it might be a mysql version issue not sure why it is not liking the LEFT Joins
I attached a file wihout those two joins
|
|
|
|
« Last Edit: November 01, 2006, 06:22:08 pm by SMFHacks »
|
Logged
|
|
|
|
|
roberto
|
|
« Reply #14 on: November 01, 2006, 06:27:08 pm » |
|
no... no work on other server...
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks.com 
SMFHacks
Members
Total Members: 10766
Stats
Users Online
Poll
Author