Piwigo.org

You are not logged in. (Register / Login)

Announcement

#1 2011-04-29 14:06:42

chaser
Member
Registered: 2011-04-29
Posts: 18

Singel Login for Webspell soceity editon and Piwigo

Tags: [migration]

Hi Guys,

iam looking for a way to combine webspell users and passwords with the piwigo gallery

any way to do this?

Offline

#2 2011-04-29 14:22:39

ddtddt
Piwigo Team
Location: Quetigny - France
Registered: 2007-07-27
Posts: 6074

Re: Singel Login for Webspell soceity editon and Piwigo

What is the encoding of passwords in Webspell ? md5 ?


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

#3 2011-04-30 19:00:51

chaser
Member
Registered: 2011-04-29
Posts: 18

Re: Singel Login for Webspell soceity editon and Piwigo

Sorry to ask were do i find the encoding.

Offline

#4 2011-04-30 19:40:51

ddtddt
Piwigo Team
Location: Quetigny - France
Registered: 2007-07-27
Posts: 6074

Re: Singel Login for Webspell soceity editon and Piwigo

I applied to the support of Webspell


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

#5 2011-04-30 19:42:27

chaser
Member
Registered: 2011-04-29
Posts: 18

Re: Singel Login for Webspell soceity editon and Piwigo

oh ok thanks ;)

Offline

#6 2011-05-01 17:53:41

ddtddt
Piwigo Team
Location: Quetigny - France
Registered: 2007-07-27
Posts: 6074

Re: Singel Login for Webspell soceity editon and Piwigo

Webspell use md5

in Webspell create a user for guest (regard userID) -> AAA
I think webmaster is userID = 1

1) install/activate [extension by Piwigo Team] LocalFiles Editor from screen [Administration > Plugins > Manage]

2) open [Administration > Plugins > LocalFiles Editor > Local config and paste the following code:

<?php

$conf['external_authentification'] = true;

$conf['user_fields'] = array(
  'userID' => 'id',
  'username' => 'username',
  'password' => 'password',
  'email' => 'mail_address'
  );

$conf['guest_id'] = AAA;

?>


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

#7 2011-05-01 17:59:05

chaser
Member
Registered: 2011-04-29
Posts: 18

Re: Singel Login for Webspell soceity editon and Piwigo

nope not working crashed the gallerie
sorry

Code:

Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 291


Warning:  [mysql error 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 '= '1'' at line 6

SELECT id AS userID
     , username AS username
     , password AS password
     , mail_address AS email
  FROM piwigo_users
  WHERE  = '1' in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153


Warning:  [mysql error 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 'FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id' at line 3

SELECT
    COUNT(1) AS counter,
  FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = 1
  GROUP BY ui.user_id
; in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 158


Warning:  [mysql error 1062] Duplicate entry '1' for key 1

INSERT INTO piwigo_user_infos
  (nb_image_line,nb_line_page,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,theme,enabled_high,level,user_id,status,registration_date)
  VALUES('5','3','de_DE',NULL,NULL,'false','false','false','7','stripped','true','8','1','webmaster','2011-05-01 17:57:42') in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined variable: user_info_query in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 326


Warning:  [mysql error 1065] Query was empty
 in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 332

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 332

Warning: Invalid argument supplied for foreach() in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 334

Notice: Undefined index: nb_image_line in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 248

Notice: Undefined index: nb_line_page in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 248

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/common.inc.php on line 139

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/common.inc.php on line 143

Warning: Cannot modify header information - headers already sent by (output started at /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php:291) in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_html.inc.php on line 500

Offline

#8 2011-05-01 18:28:10

ddtddt
Piwigo Team
Location: Quetigny - France
Registered: 2007-07-27
Posts: 6074

Re: Singel Login for Webspell soceity editon and Piwigo

sorry I'm forgotten

$conf['users_table'] = 'BBBBB';


------------
BBBBB is a name for user Webspell

normaly is prefixe table for Webspell -> CC
CC.user


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

#9 2011-05-01 18:29:15

ddtddt
Piwigo Team
Location: Quetigny - France
Registered: 2007-07-27
Posts: 6074

Re: Singel Login for Webspell soceity editon and Piwigo

ti repair go to directory local/config and rename

config.inc.php to old.config.inc.php


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

#10 2011-05-01 19:34:25

chaser
Member
Registered: 2011-04-29
Posts: 18

Re: Singel Login for Webspell soceity editon and Piwigo

so the code should be

<?php

$conf['external_authentification'] = true;

$conf['user_fields'] = array(
  'userID' => 'id',
  'username' => 'username',
  'password' => 'password',
  'email' => 'mail_address'
  );

$conf['guest_id'] = AAA;

$conf['users_table'] = 'BBBBB';


?>

Offline

#11 2011-05-01 19:38:18

chaser
Member
Registered: 2011-04-29
Posts: 18

Re: Singel Login for Webspell soceity editon and Piwigo

tried same error :(

Code:

Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 291


Warning:  [mysql error 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 '= '1'' at line 6

SELECT id AS userID
     , username AS username
     , password AS password
     , mail_address AS email
  FROM BBBBB
  WHERE  = '1' in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153


Warning:  [mysql error 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 'FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id' at line 3

SELECT
    COUNT(1) AS counter,
  FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = 1
  GROUP BY ui.user_id
; in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 158


Warning:  [mysql error 1062] Duplicate entry '1' for key 1

INSERT INTO piwigo_user_infos
  (nb_image_line,nb_line_page,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,theme,enabled_high,level,user_id,status,registration_date)
  VALUES('5','3','de_DE',NULL,NULL,'false','false','false','7','stripped','true','8','1','webmaster','2011-05-01 19:36:30') in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined variable: user_info_query in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 326


Warning:  [mysql error 1065] Query was empty
 in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 332

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 332

Warning: Invalid argument supplied for foreach() in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 334

Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 363

Notice: Undefined index: status in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 363


Warning:  [mysql error 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 '' at line 3

SELECT cat_id
  FROM piwigo_user_access
  WHERE user_id = 
; in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 200


Warning:  [mysql error 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 '' at line 4

SELECT cat_id
  FROM piwigo_user_group AS ug INNER JOIN piwigo_group_access AS ga
    ON ug.group_id = ga.group_id
  WHERE ug.user_id = 
; in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 200

Notice: Undefined index: level in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 371


Warning:  [mysql error 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 '' at line 4

SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level> in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 200

Notice: Undefined index: level in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 690


Warning:  [mysql error 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 'GROUP BY c.id, c.global_rank' at line 8
SELECT c.id AS cat_id, global_rank,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=
  GROUP BY c.id, c.global_rank in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Notice: Undefined index: status in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 392

Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 419


Warning:  [mysql error 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 '' at line 2

DELETE FROM piwigo_user_cache_categories
  WHERE user_id =  in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 437


Warning:  [mysql error 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 '' at line 2

DELETE FROM piwigo_user_cache
  WHERE user_id =  in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 445


Warning:  [mysql error 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 ''false',1304271399,'0',32,'NOT IN','0')' at line 5

INSERT INTO piwigo_user_cache
  (user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
    image_access_type, image_access_list)
  VALUES
  (,'false',1304271399,'0',32,'NOT IN','0') in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined index: nb_image_line in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 248

Notice: Undefined index: nb_line_page in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 248

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/common.inc.php on line 139

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/common.inc.php on line 143

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/plugins/FacebookPlug/include/header.inc.php on line 34

Warning: Cannot modify header information - headers already sent by (output started at /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php:291) in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_html.inc.php on line 500
Sie sind nicht berechtigt die gewünschte Seite aufzurufen
Identifikation Startseite

could it be because piwigo is in a different folder then the root site?

Offline

#12 2011-05-01 20:41:36

ddtddt
Piwigo Team
Location: Quetigny - France
Registered: 2007-07-27
Posts: 6074

Re: Singel Login for Webspell soceity editon and Piwigo

You must remplace BBB by name table user of Webspell

wbspell and piwigo are install in the same base ?


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

#13 2011-05-01 23:39:21

chaser
Member
Registered: 2011-04-29
Posts: 18

Re: Singel Login for Webspell soceity editon and Piwigo

they use the same db if you mean that

the webspell is installed here

http://hell.myntc.com

and the piwigo here

http://hell.myntc.com/gal/piwigo

ok so i gotta look up the user table in the mysql database and replace the bbbb with it right ?

Offline

#14 2011-05-02 06:49:08

ddtddt
Piwigo Team
Location: Quetigny - France
Registered: 2007-07-27
Posts: 6074

Re: Singel Login for Webspell soceity editon and Piwigo

chaser wrote:

ok so i gotta look up the user table in the mysql database and replace the bbbb with it right ?

yes Webspell user table


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

#15 2011-05-02 11:07:48

chaser
Member
Registered: 2011-04-29
Posts: 18

Re: Singel Login for Webspell soceity editon and Piwigo

Ok so i did edit the code:

<?php

$conf['external_authentification'] = true;

$conf['user_fields'] = array(
  'userID' => 'id',
  'username' => 'username',
  'password' => 'password',
  'email' => 'mail_address'
  );

$conf['guest_id'] = AAA;

$conf['users_table'] = 'tune_user';


?>


got error

Code:

Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 291



Warning:  [mysql error 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 '= '1'' at line 6

SELECT id AS userID
     , username AS username
     , password AS password
     , mail_address AS email
  FROM tune_users
  WHERE  = '1' in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153



Warning:  [mysql error 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 'FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id' at line 3

SELECT
    COUNT(1) AS counter,
  FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = 1
  GROUP BY ui.user_id
; in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 158



Warning:  [mysql error 1062] Duplicate entry '1' for key 1

INSERT INTO piwigo_user_infos
  (nb_image_line,nb_line_page,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,theme,enabled_high,level,user_id,status,registration_date)
  VALUES('5','3','de_DE',NULL,NULL,'false','false','false','7','stripped','true','8','1','webmaster','2011-05-02 11:04:48') in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined variable: user_info_query in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 326



Warning:  [mysql error 1065] Query was empty
 in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 332

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 332

Warning: Invalid argument supplied for foreach() in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 334

Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 363

Notice: Undefined index: status in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 363



Warning:  [mysql error 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 '' at line 3

SELECT cat_id
  FROM piwigo_user_access
  WHERE user_id = 
; in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 200



Warning:  [mysql error 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 '' at line 4

SELECT cat_id
  FROM piwigo_user_group AS ug INNER JOIN piwigo_group_access AS ga
    ON ug.group_id = ga.group_id
  WHERE ug.user_id = 
; in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 200

Notice: Undefined index: level in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 371



Warning:  [mysql error 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 '' at line 4

SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level> in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 200

Notice: Undefined index: level in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 690



Warning:  [mysql error 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 'GROUP BY c.id, c.global_rank' at line 8
SELECT c.id AS cat_id, global_rank,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=
  GROUP BY c.id, c.global_rank in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Notice: Undefined index: status in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 392

Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 419



Warning:  [mysql error 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 '' at line 2

DELETE FROM piwigo_user_cache_categories
  WHERE user_id =  in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 437



Warning:  [mysql error 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 '' at line 2

DELETE FROM piwigo_user_cache
  WHERE user_id =  in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined index: id in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 445



Warning:  [mysql error 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 ''false',1304327107,'0',32,'NOT IN','0')' at line 5

INSERT INTO piwigo_user_cache
  (user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
    image_access_type, image_access_list)
  VALUES
  (,'false',1304327107,'0',32,'NOT IN','0') in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/dblayer/functions_mysql.inc.php on line 654


Notice: Undefined index: nb_image_line in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 248

Notice: Undefined index: nb_line_page in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php on line 248

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/common.inc.php on line 139

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/common.inc.php on line 143

Notice: Undefined index: language in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/plugins/FacebookPlug/include/header.inc.php on line 34

Warning: Cannot modify header information - headers already sent by (output started at /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_user.inc.php:291) in /homepages/17/d42865286/htdocs/Webspell/gal/piwigo/include/functions_html.inc.php on line 500
Sie sind nicht berechtigt die gewünschte Seite aufzurufen
Identifikation Startseite

Offline

Board footer

Powered by FluxBB

About this website · Donate · Contact Piwigo project © 2002-2013