Jump to content
Sign in to follow this  
killerwhale65

photo gallery for oscommerce

Recommended Posts

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

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

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

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

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

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

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
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
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
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
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 by drumcentral

--------------------------------------------------------------------------------------------------

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×