singapore: the smallest big galery
home » forum » Installation » MySql plz he

You are not logged in.

#1 2008-05-20 15:34:41

Sep
Member

MySql plz he

Hello,

First thanks for this great gallery very nice plugin!
I ve read a lot in your forum but i coulnt find a resolution for my problem ;(

MySql Error on the installation i know i could use this csv database too but i tryed it out it loads to long if the gallery is to big like we have around 2000 400x300 screens in it plz try to give me some help to creat this 1 tabel

Server
Apache/2.2.3 (Linux/SUSE)
PHP Version
5.2.0
MySQL
5.0.26

Code:

'sg_galleries' table created.
Unable to create 'sg_images' table:Specified key was too long; max key length is 1000 bytes.
'sg_users' table created.
Inserted default users into 'sg_users' table.

Kind Regards,
Sep

Offline

 

#2 2008-05-23 19:03:34

DC
Administrator

Re: MySql plz he

It should not be too slow the great thing about SGAL is its design and that is its meant to work with out the need for a DB at all MSQL is experimental ...

We have many that run it with thousands no prob and its not slow at all so maybe your server cant handele it not sure why
as for a flat file DB SGAL is prety darn fast.

Somone here might be able to help you with the MYSQL setup as I cant help you on that one, I myself run all tests all mods on the flat file DB as its was intended to be used.

this is all on a nix box and she runs fast and solid ...

heres a site with tons of images its flat does this load slow to you.

http://www.primaveraphoto.com/

Just all in sep gals althogh this is a custom version might be becouse your trying to load too much at one time this can be a prob with any sys DB or Not ...

DC


To code or not to code that is the question?

Did my response help you out? Consider donating by buying me a slice, Whats this? Read More!
http://www.clickcraft.net/slice.php

Offline

 

#3 2008-05-27 10:15:30

Sep
Member

Re: MySql plz he

thx for your reply i found the fix for this mysql i compaired them with same settings and u are right nearly same speed ;/
maybe 1/2 sec is the mysql faster but just from main gallery view -> inside the first gallery


i just noticed the generate.php (tools) dont works with mysql unfortunately my cron job is sensless
do i have to change anything for the generate.php if i use mysql ?
cause it works pretty fine on cvs

Regards,
Sep

Offline

 

#4 2008-06-01 02:01:13

Sep
Member

Re: MySql plz he

anyone know why the gernerate.php dont works with mysql ?

Offline

 

#5 2008-08-16 09:56:44

zion22
Member

Re: MySql plz he

This fixes the issue. You need to do it manually through phpMyAdmin or such.

Code:

 CREATE TABLE sg_images(
galleryid varchar( 250 ) NOT NULL ,
filename varchar( 200 ) NOT NULL ,
lang varchar( 16 ) NOT NULL DEFAULT '',
thumbnail varchar( 255 ) ,
owner varchar( 32 ) ,
groups varchar( 64 ) ,
permissions int,
categories varchar( 64 ) ,
name varchar( 255 ) ,
artist varchar( 255 ) ,
email varchar( 255 ) ,
copyright varchar( 255 ) ,
description text,
width smallint UNSIGNED,
height smallint UNSIGNED,
TYPE tinyint UNSIGNED,
location varchar( 255 ) ,
date varchar( 255 ) ,
camera varchar( 255 ) ,
lens varchar( 255 ) ,
film varchar( 255 ) ,
darkroom text,
digital text,
hits smallint UNSIGNED,
lasthit int UNSIGNED,
PRIMARY KEY ( galleryid, filename, lang )
) TYPE = MYISAM ,
DEFAULT CHARACTER SET latin1

Offline

 

#6 2011-03-18 07:29:28

Re: MySql plz he

did anyone solve this situation? im doing it the same way but still crashes sad

Offline

 

#7 2011-04-16 14:23:11

arnold24
Member

Re: MySql plz he

Sep wrote:

thx for your reply i found the fix for this mysql i compaired them with same settings and u are right nearly same speed ;/
maybe 1/2 sec is the mysql faster but just from main gallery view -> inside the first gallery


i just noticed the generate.php (tools) dont works with mysql unfortunately my cron job is sensless
do i have to change anything for the generate.php if i use mysql ?
cause it works pretty fine on cvs

Regards,
Sep

Hi, same here unfortunately. Has there been any progress on this?
Many thanks,

Last edited by arnold24 (2011-04-16 14:25:27)


Arnold

Offline

 

#8 2011-04-21 14:31:25

DC
Administrator

Re: MySql plz he

Thanks for testing but the whole idea of SGAL is that it does not need a DB which makes it simple to set up yet fast as real DB that said,  no I am sorry but nothing has been changed as far as MYSQL goes the tools are designed to work with the flat db structure ...

However if you do get a mod that your doing working for MYSQl please do post it on here for others to try.

DC


To code or not to code that is the question?

Did my response help you out? Consider donating by buying me a slice, Whats this? Read More!
http://www.clickcraft.net/slice.php

Offline