An error occurred in script '/home/cid006/public_html/scripts/store/processSearch-contact-lenses.php' on line 61:
mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given
mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given
Array
(
[0] => Array
(
[function] => my_error_handler
[args] => Array
(
[0] => 2
[1] => mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given
[2] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
[3] => 61
[4] => Array
(
[_GET] => Array
(
)
[_POST] => Array
(
)
[_COOKIE] => Array
(
[PHPSESSID] => 24184c350a743ddaf1d61cf1e77dad85
)
[_FILES] => Array
(
)
[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses
[QUERY_STRING] =>
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_URL] => /store/contact-lenses
[REMOTE_PORT] => 6251
[SCRIPT_FILENAME] => /home/cid006/public_html/store/index.php
[SERVER_ADMIN] => webmaster@eyeglassuniverse.com
[CONTEXT_DOCUMENT_ROOT] => /home/cid006/public_html
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /home/cid006/public_html
[REMOTE_ADDR] => 18.191.215.30
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => eyeglassuniverse.com
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] =>
[PATH] => /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
[HTTP_X_HTTPS] => 1
[HTTP_HOST] => eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_COOKIE] => PHPSESSID=24184c350a743ddaf1d61cf1e77dad85
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses
[SCRIPT_URL] => /store/contact-lenses
[UNIQUE_ID] => Zz7RVRBLuQoF3u7VyoRIzwAAABM
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses
[REDIRECT_SCRIPT_URL] => /store/contact-lenses
[REDIRECT_UNIQUE_ID] => Zz7RVRBLuQoF3u7VyoRIzwAAABM
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1732170069.1815
[REQUEST_TIME] => 1732170069
[argv] => Array
(
)
[argc] => 0
)
[_REQUEST] => Array
(
)
[_ENV] => Array
(
)
[GLOBALS] => Array
(
[_GET] => Array
(
)
[_POST] => Array
(
)
[_COOKIE] => Array
(
[PHPSESSID] => 24184c350a743ddaf1d61cf1e77dad85
)
[_FILES] => Array
(
)
[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses
[QUERY_STRING] =>
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_URL] => /store/contact-lenses
[REMOTE_PORT] => 6251
[SCRIPT_FILENAME] => /home/cid006/public_html/store/index.php
[SERVER_ADMIN] => webmaster@eyeglassuniverse.com
[CONTEXT_DOCUMENT_ROOT] => /home/cid006/public_html
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /home/cid006/public_html
[REMOTE_ADDR] => 18.191.215.30
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => eyeglassuniverse.com
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] =>
[PATH] => /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
[HTTP_X_HTTPS] => 1
[HTTP_HOST] => eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_COOKIE] => PHPSESSID=24184c350a743ddaf1d61cf1e77dad85
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses
[SCRIPT_URL] => /store/contact-lenses
[UNIQUE_ID] => Zz7RVRBLuQoF3u7VyoRIzwAAABM
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses
[REDIRECT_SCRIPT_URL] => /store/contact-lenses
[REDIRECT_UNIQUE_ID] => Zz7RVRBLuQoF3u7VyoRIzwAAABM
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1732170069.1815
[REQUEST_TIME] => 1732170069
[argv] => Array
(
)
[argc] => 0
)
[_REQUEST] => Array
(
)
[_ENV] => Array
(
)
[GLOBALS] => Array
*RECURSION*
[pageID] => 100
[productURLData] => Array
(
[0] =>
[1] => store
[2] => contact-lenses
)
[productType] => contact-lenses
[validTypes] => Array
(
[0] => eyeglasses
[1] => contact-lenses
[2] => safety-glasses
[3] => reglazing
[4] => brands
[5] => test
[6] => reglazingTest
)
[productName] =>
[display] =>
[testStatus] => 1
[testMessage] => System is in TEST mode.
[_SESSION] => Array
(
)
[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1055
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[error_list] => Array
(
[0] => Array
(
[errno] => 1055
[sqlstate] => 42000
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
)
[field_count] => 4
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 8.0.35
[server_version] => 80035
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 24495588
[warning_count] => 0
)
[pageid] => 1
[q] => SELECT DISTINCT c.contactsID, m.manufacturerName, c.contactsBrandPrimary, c.contactsBrandSecondary, c.contactsPackSize, c.contactsImage, c.contactsMSRP FROM product_contacts AS c INNER JOIN manufacturers_contacts AS m ON c.contactsManufacturer = m.manufacturerID GROUP BY c.contactsBrandSecondary ORDER BY contactsMSRP LIMIT 0, 24
[r] =>
[metadataTitle] => Quality and Value in online prescription eyeglasses | EyeglassUniverse
[metadataKeywords] => eyeglasses, glasses, prescription eyeglasses, prescription glasses, buy glasses online, buy eyeglasses online, buy prescription glasses online, buy prescription eyeglasses online, eyeglasses online, glasses online, sunglasses, contact lenses
[metadataDescription] => Shop our huge selection of fashion eyeglass frames, Sunglasses, Contact Lenses, Prescription glasses for men and women, and Workplace Safety Eyewear.
[metadataRobots] => INDEX, FOLLOW
[pageHeadline] =>
[pageSubtitle] =>
[pageContent] =>
[minicartQuery] => SELECT id, user_session_id, quantity, dataJSON FROM carts WHERE user_session_id = "24184c350a743ddaf1d61cf1e77dad85" ORDER BY date_created
[minicartRequest] => mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] =>
[num_rows] => 0
[type] => 0
)
[minicartRows] => 0
[minicartSubtotal] => 0
[minicartOutput] =>
Subtotal
$0.00
[dataJSON] =>
[quantity] =>
[cartID] =>
[userID] =>
[w] =>
[pass] =>
[perPage] => 24
[startingRecord] => 0
[totalRows] =>
[pages] => 0
)
[pageID] => 100
[productURLData] => Array
(
[0] =>
[1] => store
[2] => contact-lenses
)
[productType] => contact-lenses
[validTypes] => Array
(
[0] => eyeglasses
[1] => contact-lenses
[2] => safety-glasses
[3] => reglazing
[4] => brands
[5] => test
[6] => reglazingTest
)
[productName] =>
[display] =>
[testStatus] => 1
[testMessage] => System is in TEST mode.
[_SESSION] => Array
(
)
[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1055
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[error_list] => Array
(
[0] => Array
(
[errno] => 1055
[sqlstate] => 42000
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
)
[field_count] => 4
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 8.0.35
[server_version] => 80035
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 24495588
[warning_count] => 0
)
[pageid] => 1
[q] => SELECT DISTINCT c.contactsID, m.manufacturerName, c.contactsBrandPrimary, c.contactsBrandSecondary, c.contactsPackSize, c.contactsImage, c.contactsMSRP FROM product_contacts AS c INNER JOIN manufacturers_contacts AS m ON c.contactsManufacturer = m.manufacturerID GROUP BY c.contactsBrandSecondary ORDER BY contactsMSRP LIMIT 0, 24
[r] =>
[metadataTitle] => Quality and Value in online prescription eyeglasses | EyeglassUniverse
[metadataKeywords] => eyeglasses, glasses, prescription eyeglasses, prescription glasses, buy glasses online, buy eyeglasses online, buy prescription glasses online, buy prescription eyeglasses online, eyeglasses online, glasses online, sunglasses, contact lenses
[metadataDescription] => Shop our huge selection of fashion eyeglass frames, Sunglasses, Contact Lenses, Prescription glasses for men and women, and Workplace Safety Eyewear.
[metadataRobots] => INDEX, FOLLOW
[pageHeadline] =>
[pageSubtitle] =>
[pageContent] =>
[minicartQuery] => SELECT id, user_session_id, quantity, dataJSON FROM carts WHERE user_session_id = "24184c350a743ddaf1d61cf1e77dad85" ORDER BY date_created
[minicartRequest] => mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] =>
[num_rows] => 0
[type] => 0
)
[minicartRows] => 0
[minicartSubtotal] => 0
[minicartOutput] =>
Subtotal
$0.00
[dataJSON] =>
[quantity] =>
[cartID] =>
[userID] =>
[w] =>
[pass] =>
[perPage] => 24
[startingRecord] => 0
[totalRows] =>
[pages] => 0
)
)
)
[1] => Array
(
[file] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
[line] => 61
[function] => mysqli_fetch_array
[args] => Array
(
[0] =>
[1] => 2
)
)
[2] => Array
(
[file] => /home/cid006/public_html/store/index.php
[line] => 72
[args] => Array
(
[0] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
)
[function] => require
)
)
