Sivu: palviranta.fi/index.phpdo=showCart
Ongelma: Table 'palviranta.pay' doesn't exist
Sql: SELECT pay_id, pay_name, pay_cost
FROM pay
WHERE pay_only_admin IS NULL
ORDER BY pay_cost
POST = Array
(
)
REFERER = http://www.palviranta.fi/cartArray
(
[0] => Array
(
[file] => /home/palviranta/public_html/controllers/cart.php
[line] => 138
[function] => query
[class] => DB_connection
[object] => Database Object
(
[table] => Array
(
[locations] => jbb3_mod_jalleenmyyjat
[languages] => jbb3_languages
[question_fields] => jbb3_question_fields
[question_values] => jbb3_question_values
[attachments] => jbb3_attachments
[cart] => cart
[options] => options
[product] => product
[image] => product_image
[product_categories] => product_categories
[product_property] => product_property
[product2property] => product_to_property
[product_options] => product_options
[product2category] => product_to_category
[row2options] => row_to_options
[row2property] => row_to_property
[user_options] => user_options
[user2options] => users_to_options
[tags] => tags
[tagsjoin] => tags_to_product
[users] => users
[address] => address
[pages] => pages
[texts] => texts
[delivery] => delivery
[orders] => orders
[order_invoice] => order_invoice
[order_invoice_property] => order_invoice_property
[order_special] => order_special
[order_content] => order_content
[pay] => pay
[pay_has_delivery] => pay_has_delivery
[offers] => offers
[offer_has_pay] => offer_has_pay
[coupon_history] => coupon_history
[epay] => epay
[event_log] => event_log
)
[connection] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 1146
[error] => Table 'palviranta.pay' doesn't exist
[error_list] => Array
(
[0] => Array
(
[errno] => 1146
[sqlstate] => 42S02
[error] => Table 'palviranta.pay' doesn't exist
)
)
[field_count] => 16
[host_info] => mysql-remote.testivedos.com via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.5.10-MariaDB
[server_version] => 50505
[stat] => Uptime: 60850566 Threads: 151 Questions: 44422740444 Slow queries: 45786 Opens: 2189313169 Open tables: 2000 Queries per second avg: 730.030
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 368742614
[warning_count] => 0
)
[sql_list] => Array
(
)
[db_result] => mysqli_result Object
(
[current_field] => 0
[field_count] => 16
[lengths] =>
[num_rows] => 0
[type] => 0
)
[tables] =>
)
[type] => ->
[args] => Array
(
[0] => SELECT pay_id, pay_name, pay_cost
FROM pay
WHERE pay_only_admin IS NULL
ORDER BY pay_cost
)
)
[1] => Array
(
[file] => /home/palviranta/public_html/index.php
[line] => 97
[function] => runControl
[args] => Array
(
)
)
)
Warning: mysqli_error(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/palviranta/public_html/extranet/inc/core/core_mysql_db11.php on line 54
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/palviranta/public_html/extranet/inc/core/core_mysql_db11.php on line 54
Ongelma.
SELECT pay_id, pay_name, pay_cost
FROM pay
WHERE pay_only_admin IS NULL
ORDER BY pay_cost