English
Brasil
Dansk
Deutsch
Español
Français
Italiano
Magyar
Nederlands
Polski
Türkçe
Русский
简体中文Announcement
- [2013-04-19] Piwigo 2.5.1
- [2013-04-08] New server for Piwigo.org
- [2013-04-01] Piwigo and Zenphoto to join forces!
- [2013-03-04] Piwigo 2.5
- [2013-02-23] Piwigo 2.5.0RC2
- Forum Index
- » How-To and Troubleshooting
- » Singel Login for Webspell soceity editon and Piwigo
Post a reply
Topic review (newest first)
- chaser
- 2011-05-09 11:53:45
Hey ddtddt
any solution already?
Thanks!
- ddtddt
- 2011-05-03 15:30:11
ok I seek
- chaser
- 2011-05-03 14:16:40
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 StartseiteAn i cant reset the gallery by deleting the config file in the local folder ok now this reriously crashed the thing
- chaser
- 2011-05-03 14:05:07
Greate now this works perfect thanks a Lot for you help !
Its greatly appreciated!
- ddtddt
- 2011-05-03 08:09:14
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;
?>
- chaser
- 2011-05-02 23:34:48
ok here the link
http://www.webspell.org/index.php?site= … mp;file=40
- ddtddt
- 2011-05-02 21:21:37
Can you give me a link to Download version of Webspell you use ?
- chaser
- 2011-05-02 21:14:52
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- ddtddt
- 2011-05-02 21:06:46
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
- chaser
- 2011-05-02 11:16:15
i add a print view from the SQL database
- chaser
- 2011-05-02 11:07:48
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- ddtddt
- 2011-05-02 06:49:08
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
- chaser
- 2011-05-01 23:39:21
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 ?
- ddtddt
- 2011-05-01 20:41:36
You must remplace BBB by name table user of Webspell
wbspell and piwigo are install in the same base ?
- chaser
- 2011-05-01 19:38:18
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 Startseitecould it be because piwigo is in a different folder then the root site?