photo gallery for oscommerce

[azer]

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

[killerwhale65]

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!

[aneco]

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

[zaini]

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 !

[zaini]

There is a but on gallery.php : to fix, set :

 

at the very start

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link('gallery.php'));

[zaini]

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?

[drumcentral]

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!

[killerwhale65]

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?

[killerwhale65]

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 ...

[killerwhale65]

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?

[drumcentral]

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

[killerwhale65]

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!

[zaini]

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.

[drumcentral]

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

[drumcentral]

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

[vibe107fm]

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

[zaini]

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

[zaini]

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

[drumcentral]

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

[zaini]

Yes, I will probably add your short code to the head section.

In all case, it is a nice contrib

[vibe107fm]

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?

[drumcentral]

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

[vibe107fm]

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

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?

[killerwhale65]

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.

[aneco]

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.