Announcement

#1 2011-05-18 02:15:07

wncmacs
Guest

Piwigo Installation Has Gone Wrong

I made sure my host had upgraded MySQL and PHP to version 5 of each.

I ran the install.php and Piwigo reported that it had successfully installed. But when I visit my installation at http://www.mitchellraces.com/piwigo/ , the login screen loads, but a whole host of warnings load behind it and I cannot log into the site. The warnings I receive are listed below.

Anyone have an idea on what I might have done wrong, or what I could do to fix things?

wncmacs

Warning: [mysql error 1146] Table 'races_photos.piwigo_config' doesn't exist

SELECT param, value
FROM piwigo_config

; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 148 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153
Warning: [mysql error 1146] Table 'races_photos.piwigo_plugins' doesn't exist

SELECT * FROM piwigo_plugins
  WHERE state='active' in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153
Warning: [mysql error 1146] Table 'races_photos.piwigo_sessions' doesn't exist

SELECT data
  FROM piwigo_sessions
  WHERE id = '4107ng3ojqv0nub694ubt3dmh357n4'
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: [mysql error 1146] Table 'races_photos.piwigo_users' doesn't exist

SELECT id AS id
     , username AS username
     , password AS password
     , mail_address AS email
  FROM piwigo_users
  WHERE id = '2' in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153
Warning: [mysql error 1146] Table 'races_photos.piwigo_user_infos' doesn't exist

SELECT
    ui.*,
    uc.*,
    t.name AS theme_name
  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 = 2
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153 Warning: array_merge(): Argument #1 is not an array in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 332 Warning: array_merge(): Argument #2 is not an array in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 332 Warning: Invalid argument supplied for foreach() in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 334 Notice: Undefined index: id in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 363 Notice: Undefined index: status in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 363
Warning: [mysql error 1146] Table 'races_photos.piwigo_categories' doesn't exist

SELECT id
  FROM piwigo_categories
  WHERE status = 'private'
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/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 '' at line 3

SELECT cat_id
  FROM piwigo_user_access
  WHERE user_id =
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/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 /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 200
Warning: [mysql error 1146] Table 'races_photos.piwigo_categories' doesn't exist

SELECT id
  FROM piwigo_categories
  WHERE visible = 'false'
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153 Notice: Undefined index: level in /hsphere/local/home/races/mitchellraces.com/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 /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 200
Warning: [mysql error 1146] Table 'races_photos.piwigo_image_category' doesn't exist

SELECT COUNT(DISTINCT(image_id)) as total
  FROM piwigo_image_category
  WHERE category_id NOT IN (0)
    AND image_id NOT IN (0) in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 158 Notice: Undefined index: level in /hsphere/local/home/races/mitchellraces.com/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 /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153 Notice: Undefined index: status in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 392 Notice: Undefined index: id in /hsphere/local/home/races/mitchellraces.com/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 /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Notice: Undefined index: id in /hsphere/local/home/races/mitchellraces.com/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 /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Notice: Undefined index: id in /hsphere/local/home/races/mitchellraces.com/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',1305676794,'0',,'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',1305676794,'0',,'NOT IN','0') in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Notice: Undefined index: status in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 241 Notice: Undefined index: nb_image_line in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 248 Notice: Undefined index: nb_line_page in /hsphere/local/home/races/mitchellraces.com/piwigo/include/functions_user.inc.php on line 248
Warning: [mysql error 1146] Table 'races_photos.piwigo_user_infos' doesn't exist
SELECT * FROM piwigo_user_infos WHERE user_id = 2; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153
Warning: [mysql error 1146] Table 'races_photos.piwigo_languages' doesn't exist

SELECT id, name
  FROM piwigo_languages
  ORDER BY name ASC
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 153
Warning: [mysql error 1146] Table 'races_photos.piwigo_config' doesn't exist

DELETE
  FROM piwigo_config
  WHERE param = 'local_data_dir_checked'
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: [mysql error 1146] Table 'races_photos.piwigo_config' doesn't exist

INSERT
  INTO piwigo_config
  (param, value)
  VALUES('local_data_dir_checked', 'true')
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: [mysql error 1146] Table 'races_photos.piwigo_config' doesn't exist

DELETE
  FROM piwigo_config
  WHERE param = 'combined_dir_checked'
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: [mysql error 1146] Table 'races_photos.piwigo_config' doesn't exist

INSERT
  INTO piwigo_config
  (param, value)
  VALUES('combined_dir_checked', 'true')
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: [mysql error 1146] Table 'races_photos.piwigo_images' doesn't exist

SELECT
    COUNT(*)
  FROM piwigo_images
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 158 Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php:200) in /hsphere/local/home/races/mitchellraces.com/piwigo/include/no_photo_yet.inc.php on line 61
Welcome to your Piwigo photo gallery!

Username


Password



... or browse your empty gallery
Warning: [mysql error 1146] Table 'races_photos.piwigo_sessions' doesn't exist

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('4107ng3ojqv0nub694ubt3dmh357n4','',now())
; in /hsphere/local/home/races/mitchellraces.com/piwigo/include/dblayer/functions_mysql.inc.php on line 654

 

#2 2011-05-18 09:09:48

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13791

Re: Piwigo Installation Has Gone Wrong

Hi wncmacs,

It seems you have no table in your Piwigo database. Can you open a MySQL browser (like PhpMyAdmin) and see which piwigo_* are created in your database?

Offline

 

Board footer

Powered by FluxBB

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