Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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

Link to comment
Share on other sites

  • Replies 320
  • Created
  • Last Reply

Top Posters In This Topic

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

Link to comment
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

Link to comment
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 !

Link to comment
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!

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

Link to comment
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--

Link to comment
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--

Link to comment
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--

Link to comment
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

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

Link to comment
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--

Link to comment
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.

Link to comment
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

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

Link to comment
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

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

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
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

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

Link to comment
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?

Link to comment
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

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

Link to comment
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?

Link to comment
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--

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...