Announcement

 

Pages: 1 2

#16 2011-05-02 11:16:15

chaser
Member
2011-04-29
18

Re: Singel Login for Webspell soceity editon and Piwigo

i add a print view from the SQL database

http://hell.myntc.com/eventsflyer/SQL.jpg

Last edited by chaser (2011-05-02 11:19:43)

Offline

 

#17 2011-05-02 21:06:46

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: Singel Login for Webspell soceity editon and Piwigo

chaser wrote:

<?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';


?>

you dont update this !
Yous must create a news user in Webspell with 0 permission for be guest user for piwigo ans update AAA with id_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

 

#18 2011-05-02 21:14:52

chaser
Member
2011-04-29
18

Re: Singel Login for Webspell soceity editon and Piwigo

OK change source:


<?php

$conf['external_authentification'] = true;

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

$conf['guest_id'] = 4;

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


?>

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_user
  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 21:13:21') 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',1304363601,'0',30,'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',1304363601,'0',30,'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

Offline

 

#19 2011-05-02 21:21:37

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: Singel Login for Webspell soceity editon and Piwigo

Can you give me a link to  Download version of Webspell you use ?

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

 

#20 2011-05-02 23:34:48

chaser
Member
2011-04-29
18

Re: Singel Login for Webspell soceity editon and Piwigo

ok here the link

http://www.webspell.org/index.php?site= … mp;file=40

Offline

 

#21 2011-05-03 08:09:14

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: Singel Login for Webspell soceity editon and Piwigo

ok

Can you test

<?php


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

$conf['external_authentification'] = false;

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

$conf['guest_id'] = 4;

?>

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

 

#22 2011-05-03 14:05:07

chaser
Member
2011-04-29
18

Re: Singel Login for Webspell soceity editon and Piwigo

Greate now this works perfect thanks a Lot for you help !

Its greatly appreciated!

Offline

 

#23 2011-05-03 14:16:40

chaser
Member
2011-04-29
18

Re: Singel Login for Webspell soceity editon and Piwigo

hmm ok or maybe not :(

i registered a new user in webspell tried to login with this user into the gallerie and got

Code:

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',1304424888,'0',30,'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',1304424888,'0',30,'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:332) 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

An i cant reset the gallery by deleting the config file in the local folder ok now this reriously crashed the thing

Last edited by chaser (2011-05-03 14:22:09)

Offline

 

#24 2011-05-03 15:30:11

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: Singel Login for Webspell soceity editon and Piwigo

ok I seek

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

 

#25 2011-05-09 11:53:45

chaser
Member
2011-04-29
18

Re: Singel Login for Webspell soceity editon and Piwigo

Hey ddtddt

any solution already?

Thanks!

Offline

 

Pages: 1 2

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact