| Technical information |
Error type | 256 |
Error description | -22 There are no more rows in the active result set. Since this result set is not scrollable, no more data may be retrieved.<br> |
URL | criticalsettings.com/cat_product_chartview_list.php?goto=2 |
Error file | H:\root\home\lexcelaspsites-001\www\criticalsettings\connections\Connection.php |
Error line | 668 |
SQL query | SELECT
top 40 [category], [product], [version], [datecreated], [datemodified], [cur_status], [trusted_account_id], [id], [all_three_combo], [account_id], [admin_comments], [client_comments], [keywords], [parent_account_id], [num], [all_key_ids], [url], [topic_pass], [topic_img], [image4topics], [admin_temp_text], [client_temp_text], [admin_fake_text], [client_fake_text], [cs_sortorder], [image_filename], [topic_user], [backup_url], [visibility], [temp_image], [xxadmin_comments], [xxclient_comments], [ifblankimage], [fixeddate], [datedescription], [criticaltime], [cd_month_year], [extra_cd_info], [company], [firstname], [lastname], [street_address], [city], [state], [zipcode], [phone1], [email], [combo_info], [alertmsg], [mostrecentbirthday], [copied_fromwho]
FROM [dbo].[cat_product_tbl] WHERE ( ( ( (trusted_account_id like '%E4B2022F%' and cur_status = 'Shareable' ) or (account_id = 'E4B2022F') ) ) ) ORDER BY 8 ASC |
#0 |
connections\Connection.php:668 |
Connection->triggerError |
0. -22 There are no more rows in the active result set. Since this result set is not scrollable, no more data may be retrieved.<br> |
#1 |
connections\MSSQLSrvConnection.php:52 |
MSSQLSrvConnection->triggerErrorMSSQL |
N/A |
#2 |
connections\MSSQLSrvConnection.php:141 |
MSSQLSrvConnection->fetch_array |
0. Resource id #8 |
#3 |
connections\Connection.php:402 |
Connection->seekRecord |
0. Resource id #8 1. 20 |
#4 |
connections\QueryResult.php:134 |
QueryResult->seekRecord |
0. 20 |
#5 |
connections\dbfunctions\MSSQLFunctions.php:115 |
MSSQLFunctions->limitedQuery |
0. MSSQLSrvConnection 1. SELECT
top 40 [category], [product], [version], [datecreated], [datemodified], [cur_status], [trusted_account_id], [id], [all_three_combo], [account_id], [admin_comments], [client_comments], [keywords], [parent_account_id], [num], [all_key_ids], [url], [topic_pass], [topic_img], [image4topics], [admin_temp_text], [client_temp_text], [admin_fake_text], [client_fake_text], [cs_sortorder], [image_filename], [topic_user], [backup_url], [visibility], [temp_image], [xxadmin_comments], [xxclient_comments], [ifblankimage], [fixeddate], [datedescription], [criticaltime], [cd_month_year], [extra_cd_info], [company], [firstname], [lastname], [street_address], [city], [state], [zipcode], [phone1], [email], [combo_info], [alertmsg], [mostrecentbirthday], [copied_fromwho]
FROM [dbo].[cat_product_tbl] WHERE ( ( ( (trusted_account_id like '%E4B2022F%' and cur_status = 'Shareable' ) or (account_id = 'E4B2022F') ) ) ) ORDER BY 8 ASC 2. 20 3. 20 4. 1 |
#6 |
connections\Connection.php:608 |
Connection->limitedQuery |
0. SELECT
[category], [product], [version], [datecreated], [datemodified], [cur_status], [trusted_account_id], [id], [all_three_combo], [account_id], [admin_comments], [client_comments], [keywords], [parent_account_id], [num], [all_key_ids], [url], [topic_pass], [topic_img], [image4topics], [admin_temp_text], [client_temp_text], [admin_fake_text], [client_fake_text], [cs_sortorder], [image_filename], [topic_user], [backup_url], [visibility], [temp_image], [xxadmin_comments], [xxclient_comments], [ifblankimage], [fixeddate], [datedescription], [criticaltime], [cd_month_year], [extra_cd_info], [company], [firstname], [lastname], [street_address], [city], [state], [zipcode], [phone1], [email], [combo_info], [alertmsg], [mostrecentbirthday], [copied_fromwho]
FROM [dbo].[cat_product_tbl] WHERE ( ( ( (trusted_account_id like '%E4B2022F%' and cur_status = 'Shareable' ) or (account_id = 'E4B2022F') ) ) ) ORDER BY 8 ASC 1. 20 2. 20 3. 1 |
#7 |
classes\datasource\table.php:629 |
DataSourceTable->getListImpl |
0. DsCommand |
#8 |
classes\datasource\datasource.php:44 |
DataSource->getList |
0. DsCommand |
#9 |
classes\listpage.php:2053 |
ListPage->getRecordset |
N/A |
#10 |
classes\listpage.php:2204 |
ListPage->prepareForBuildPage |
N/A |
#11 |
cat_product_chartview_list.php:158 |
Global scope |
N/A |