azer 0 Posted August 26, 2008 nice feature, allow user to create, rename, remove categories of image would be a very handfull features, moderation in admin to decide if pics are on or off any time table for that MS2 Share this post Link to post Share on other sites
killerwhale65 0 Posted August 26, 2008 nice feature,allow user to create, rename, remove categories of image would be a very handfull features, moderation in admin to decide if pics are on or off any time table for that thanks, Subcategories and admin are planned features. I do not have a timetable for that yet, please keep an eye on this forum! Matthias Thoen my contribution: Photo Gallery for osCommerce --check my homepage in my CARD-- Share this post Link to post Share on other sites
aneco 0 Posted August 26, 2008 Ok it's early good !!!!!!!I have succeeded to install your contrib, but, when I want to upload a photo (after register or not), I choose my picture, and in clicking on "upload", it display the open_account page .... An idea please? I have the same problem. I also get the login screen after uploading a file, but the file is not uploaded. what did you change to solve the problem Share this post Link to post Share on other sites
zaini 0 Posted August 26, 2008 Ok, my problem was the follwing : Don't test the contrib with an installation on your local server Otherwise, you will success in installing the contrib, but you wont be able to upload any images ! I will add to favorite this forum. Is it possible to add, in future, a possibility to allow visitors to give minds/messages on photos? With a moderator party, it will be wonderful ! Share this post Link to post Share on other sites
zaini 0 Posted August 26, 2008 There is a but on gallery.php : to fix, set : at the very start $breadcrumb->add(NAVBAR_TITLE, tep_href_link('gallery.php')); Share this post Link to post Share on other sites
zaini 0 Posted August 26, 2008 There is another bug : when I deleted one picture or more, and I want to up a new, It displays the old picture and dont load the new... normal? Share this post Link to post Share on other sites
drumcentral 0 Posted August 27, 2008 There is another bug : when I deleted one picture or more, and I want to up a new, It displays the old picture and dont load the new...normal? I've just noticed that I have the same problem! -------------------------------------------------------------------------------------------------- Share this post Link to post Share on other sites
killerwhale65 0 Posted August 27, 2008 I have the same problem. I also get the login screen after uploading a file, but the file is not uploaded. what did you change to solve the problem gallery_user.php requests a customer_id to be registered (so you must be logged in). For some reason you get logged out when uploading a pic. Can you confirm that, when you click upload, then you are transfered to the login page. If you now DO NOT LOGIN, but go to account.php directly: what happens? Do you see the account page or the login screen? Matthias Thoen my contribution: Photo Gallery for osCommerce --check my homepage in my CARD-- Share this post Link to post Share on other sites
killerwhale65 0 Posted August 27, 2008 Ok, my problem was the follwing : Don't test the contrib with an installation on your local server Otherwise, you will success in installing the contrib, but you wont be able to upload any images ! It does work on my local server using XAMPP. Not sure what you are using, but it does work locally. Is it possible to add, in future, a possibility to allow visitors to give minds/messages on photos?With a moderator party, it will be wonderful ! Yes, see planned features ... Matthias Thoen my contribution: Photo Gallery for osCommerce --check my homepage in my CARD-- Share this post Link to post Share on other sites
killerwhale65 0 Posted August 27, 2008 There is a but on gallery.php : to fix, set : at the very start $breadcrumb->add(NAVBAR_TITLE, tep_href_link('gallery.php')); ok, sorry i dont use the breadcrumb, thats why it was not there. But i will add it. There is another bug : when I deleted one picture or more, and I want to up a new, It displays the old picture and dont load the new...normal? Most likely the old pic is still in your browsers cache. Please check via FTP in the gallery folder if the new picture is actually there. Is this about both the thumbnail and full-size, or only about the thumbnal? Matthias Thoen my contribution: Photo Gallery for osCommerce --check my homepage in my CARD-- Share this post Link to post Share on other sites
drumcentral 0 Posted August 27, 2008 ok, sorry i dont use the breadcrumb, thats why it was not there. But i will add it. Most likely the old pic is still in your browsers cache. Please check via FTP in the gallery folder if the new picture is actually there. Is this about both the thumbnail and full-size, or only about the thumbnal? Thanks. Yes, I has assumed that it was a cache issue. Just wasn't sure if it was a local or oscommerce online cache. After forcing a refresh it all appeared. I might put that info on the gallery page to help users. Kenny -------------------------------------------------------------------------------------------------- Share this post Link to post Share on other sites
killerwhale65 0 Posted August 27, 2008 Thanks. Yes, I has assumed that it was a cache issue. Just wasn't sure if it was a local or oscommerce online cache.After forcing a refresh it all appeared. I might put that info on the gallery page to help users. Kenny ok, will do! Matthias Thoen my contribution: Photo Gallery for osCommerce --check my homepage in my CARD-- Share this post Link to post Share on other sites
zaini 0 Posted August 27, 2008 Thanks. Yes, I has assumed that it was a cache issue. Just wasn't sure if it was a local or oscommerce online cache.After forcing a refresh it all appeared. I might put that info on the gallery page to help users. Kenny Yes exactly, we have to refresh many times ;) And I use EasyPHP on local -> dont work locally I have up directly -> Nikel I have modify 100k to 1M (100k is too small), and extend 800*600 to 1280*1024. I add also extension : $allowed_extensions = array('jpg','JPG','jpeg','JPEG'); Because, if my file is JPG, it doesnt work. Share this post Link to post Share on other sites
drumcentral 0 Posted August 27, 2008 Yes exactly, we have to refresh many times ;) And I use EasyPHP on local -> dont work locally I have up directly -> Nikel I have modify 100k to 1M (100k is too small), and extend 800*600 to 1280*1024. I add also extension : $allowed_extensions = array('jpg','JPG','jpeg','JPEG'); Because, if my file is JPG, it doesnt work. Hi there. I make all my changes on my live site! I wish there was a way to force a refresh on the customer/users browser. Some people using the gallery for the first time might not know how to do that, or understand what it means. I think I will follow your changes. I did think that 100k and 800/600 was too small for most people. And I will add the extensions as you did. Many thanks. Kenny -------------------------------------------------------------------------------------------------- Share this post Link to post Share on other sites
drumcentral 0 Posted August 27, 2008 I may have found a way to make the pages show the new uploaded images by using an old-fashioned bit of java script: I've put this into both gallery.php and gallery_user.php Place this at the top of your page, in the head part: <script language=" JavaScript" ><!-- function MyReload() { window.location.reload(); } //--></script> [b]Then change your <Body> to say;[/b] <Body onLoad=" MyReload()" > let me know if this works for you. Kenny -------------------------------------------------------------------------------------------------- Share this post Link to post Share on other sites
vibe107fm 0 Posted August 27, 2008 Hiya. I am installing the Photogallery on my store, but there seems to be an error in the SQL as I get this error message: Any ideas whats up? Thanks Error SQL-query : CREATE TABLE `gallery` ( `id` int( 4 ) NOT NULL AUTO_INCREMENT , `cID` int( 4 ) NOT NULL , `pID` int( 4 ) NOT NULL , PRIMARY KEY ( `id` ) )ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =18 MySQL said: #1064 - 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 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT Share this post Link to post Share on other sites
zaini 0 Posted August 27, 2008 I dont know if it is the problem of your SQL-query, but, at the end, you have forgotten " ; " CREATE TABLE `gallery` ( `id` int(4) NOT NULL auto_increment, `cID` int(4) NOT NULL, `pID` int(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=18; And verify if you have not already a table named gallery, it could create conflicts. Delete table gallery, and apply again the query Share this post Link to post Share on other sites
zaini 0 Posted August 27, 2008 I may have found a way to make the pages show the new uploaded images by using an old-fashioned bit of java script: I've put this into both gallery.php and gallery_user.php Place this at the top of your page, in the head part: <script language=" JavaScript" ><!-- function MyReload() { window.location.reload(); } //--></script> [b]Then change your <Body> to say;[/b] <Body onLoad=" MyReload()" > let me know if this works for you. Kenny No changements with this. I will just advertise visitors that they have to wait a few minutes and refresh the page before seing their new photo Share this post Link to post Share on other sites
drumcentral 0 Posted August 27, 2008 No changements with this.I will just advertise visitors that they have to wait a few minutes and refresh the page before seing their new photo Hmm. okay, I've just added this to the head section of gallery.php: <meta http-equiv="refresh" content="30"> This will force a refresh after 30 seconds, or however many seconds you like. Not an ideal fix, but it might help. Kenny -------------------------------------------------------------------------------------------------- Share this post Link to post Share on other sites
zaini 0 Posted August 27, 2008 Yes, I will probably add your short code to the head section. In all case, it is a nice contrib Share this post Link to post Share on other sites
vibe107fm 0 Posted August 27, 2008 I dont know if it is the problem of your SQL-query, but, at the end, you have forgotten " ; " CREATE TABLE `gallery` ( `id` int(4) NOT NULL auto_increment, `cID` int(4) NOT NULL, `pID` int(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=18; And verify if you have not already a table named gallery, it could create conflicts. Delete table gallery, and apply again the query Hiya. Thanks for the reply, just checked the SQL, and its still the same..... used the one supplied with the contrib, but still the same error! (no gallery table too)! any ideas? Share this post Link to post Share on other sites
drumcentral 0 Posted August 27, 2008 (edited) Hiya. Thanks for the reply, just checked the SQL, and its still the same..... used the one supplied with the contrib, but still the same error! (no gallery table too)! any ideas? It might be that your server is running SQL 4 (maybe?) the text below is the start of the MYSQL from the contrib which seems to say that it's for version 5.0.21 Maybe I'm wrong..... Can you find out which version of MYSQL is on your server? -- phpMyAdmin SQL Dump -- version 2.8.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generatie Tijd: 24 Aug 2008 om 12:57 -- Server versie: 5.0.21 -- PHP Versie: 5.1.4 -- I've also noticed that there should be a space just before the last ';' So it should be: AUTO_INCREMENT=18 ; but yours is: AUTO_INCREMENT=18; Of course, this may make no difference at all!! Kenny Edited August 27, 2008 by drumcentral -------------------------------------------------------------------------------------------------- Share this post Link to post Share on other sites
vibe107fm 0 Posted August 27, 2008 It might be that your server is running SQL 4 (maybe?) the text below is the start of the MYSQL from the contrib which seems to say that it's for version 5.0.21Maybe I'm wrong..... Can you find out which version of MYSQL is on your server? -- phpMyAdmin SQL Dump -- version 2.8.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generatie Tijd: 24 Aug 2008 om 12:57 -- Server versie: 5.0.21 -- PHP Versie: 5.1.4 -- I've also noticed that there should be a space just before the last ';' So it should be: AUTO_INCREMENT=18 ; but yours is: AUTO_INCREMENT=18; Of course, this may make no difference at all!! Kenny hiya Kenny, From my server_info.php (catalogue/admin/) this is the info i can find on the PHP server: Database: MySQL 4.0.30-log Does this matter? Share this post Link to post Share on other sites
killerwhale65 0 Posted August 28, 2008 hiya Kenny, From my server_info.php (catalogue/admin/) this is the info i can find on the PHP server: Database: MySQL 4.0.30-log Does this matter? Hello, It's possible that it does not work on mysql 4, its been made for version 5. I advise you to do things manually, its only 1 table with 3 fields so not that much work. First make a new table called 'gallery'. In this freshly created gallery, make 3 fields: id, make this primary key and auto-increment cID pID Set the type for all 3: INT(4) That's it. Matthias Thoen my contribution: Photo Gallery for osCommerce --check my homepage in my CARD-- Share this post Link to post Share on other sites
aneco 0 Posted August 28, 2008 Hi, it is a super contri, THANKS It would be nice if in a next version the photos could be stored and shown in folders. Share this post Link to post Share on other sites