miamirealtor

Fixed

OK this is strange. But it does work out in our favor regardless.

I changed
Maximum number of rows to retrieve from the DB for the Admin display from blank to 596 and went to the admin section to view the database. The page nation has disappeared, I am not seeing 596 results being displayed but 10 by default with the option to only change up to 100 and not 596. But when I do a search, it searches through all 596 results without having to do a search on each page. Does that make sense? lol

Before I had a problem when doing searches where I would have to perform a search on each page. Bummer, especially when you have 60 pages.

Now since I can do 1 search for all results that problem is resolved!

Which also means I really do not need all 596 results being displayed in the admin section since I can just perform one search for all data.

<select name=”cf2dbtable_length” size=”1″>
<option value=”10″>10</option>
<option value=”25″>25</option>
<option value=”50″>50</option>
<option value=”100″>100</option>
<option value=”500″>500</option></select>

Yeah but after I change the number of results to display in the database options to 500, it still will not let me change the results on the drop down from 10 to 100. The cap is at 100. Is there a way to change this?

Worked! Wow, that was fun… ?? Thank you once again…

I run this query and all is OK:

SELECT submit_time AS ‘Submitted’,
max(if(field_name=’ML-Number’, field_value, null )) AS ‘ML-Number’,
max(if(field_name=’Notes’, field_value, null )) AS ‘Notes’,
max(if(field_name=’Status’, field_value, null )) AS ‘Status’,
max(if(field_name=’property-address’, field_value, null )) AS ‘property-address’,
max(if(field_name=’listing-agent’, field_value, null )) AS ‘listing-agent’,
max(if(field_name=’agent-phone’, field_value, null )) AS ‘agent-phone’,
max(if(field_name=’agent-email’, field_value, null )) AS ‘agent-email’,
max(if(field_name=’Asst’, field_value, null )) AS ‘Asst’,
max(if(field_name=’Submit-Date’, field_value, null )) AS ‘Submit-Date’,
max(if(field_name=’List-Price’, field_value, null )) AS ‘List-Price’,
max(if(field_name=’Bid-Amount’, field_value, null )) AS ‘Bid-Amount’,
max(if(field_name=’Deposit-AMT’, field_value, null )) AS ‘Deposit-AMT’,
max(if(field_name=’follow-up-date’, field_value, null )) AS ‘follow-up-date’,
max(if(field_name=’Submitted From’, field_value, null )) AS ‘Submitted From’,
GROUP_CONCAT(if(file is null or length(file) = 0, null, field_name)) AS ‘fields_with_file’
FROM wp_cf7dbplugin_submits
WHERE form_name = ‘Untitled’
GROUP BY submit_time
ORDER BY submit_time DESC
LIMIT 0,100

Results:

SELECT submit_time AS ‘Submitted’,
max#if#field_na#e=’ML-Number’, field_value, null ## AS ‘ML-Number’,
max#if#field_na#e=’Notes’, field_value, null ## AS ‘Notes’,
max#if#field_na#e=’Status’, field_value, null ## AS ‘Status’,
max#if#field_na#e=’property-address’, field_value, null ## AS ‘property-address’,
max#if#field_na#e=’listing-agent’, field_value, null ## AS ‘listing-agent’,
max#if#field_na#e=’agent-phone’, field_value, null ## AS ‘agent-phone’,
max#if#field_na#e=’agent-email’, field_value, null ## AS ‘agent-email’,
max#if#field_na#e=’Asst’, field_value, null ## AS ‘Asst’,
max#if#field_na#e=’Submit-Date’, field_value, null ## AS ‘Submit-Date’,
max#if#field_na#e=’List-Price’, field_value, null ## AS ‘List-Price’,
max#if#field_na#e=’Bid-Amount’, field_value, null ## AS ‘Bid-Amount’,
max#if#field_na#e=’Deposit-AMT’, field_value, null ## AS […]

so my question remains. How do I manually delete field names?

I ran that query and got these results:

SELECT submit_time AS ‘Submitted’, max#if#field_na#e=’ML-Number’, field_value, null ## AS ‘ML-Number’, max#if#field_na#e=’Notes’, field_value, null ## AS ‘Notes’, max#if#field_na#e=’Sent a couple of follow up emails# LAst one is 11/27/11 if they respond w counter MArios’s highest is 45k# If its rejected subm’, field_value, null ## AS ‘Sent a couple of follow up emails# LAst one is 11/27/11 if they respond w counter MArios’s highest is 45k# If its rejected subm’, max#if#field_na#e=’Sent Email requesting showing instructions Mario ”really wants property” # – pss 11/25/11′, field_value, null ## AS ‘Sent Email requesting showing instructions Mario ”really wants property” # – pss 11/25/11’, max#if#field_na#e=’Status’, field_value, null ## AS ‘Status’, max#if#field_na#e=’property-address’, field_value, null ## AS ‘property-address’, max#if#field_na#e=’listing-agent’, field_value, null ## AS ‘listing-agent’, max#if(field_na#e=’agent-phone’, […]

MySQL said:
#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 ‘s highest is 45k. If its rejected subm’, field_value, null )) AS ‘Sent a coupl’ at line 4

OK I am still on it. I found the error in the query that is being exported by the backend.

Query:

SELECT submit_time AS ‘Submitted’,
max(if(field_name=’ML-Number’, field_value, null )) AS ‘ML-Number’,
max(if(field_name=’Notes’, field_value, null )) AS ‘Notes’,
max(if(field_name=’Sent a couple of follow up emails. LAst one is 11/27/11 if they respond w counter MArios’s highest is 45k. If its rejected subm’, field_value, null )) AS ‘Sent a couple of follow up emails. LAst one is 11/27/11 if they respond w counter MArios’s highest is 45k. If its rejected subm’,
max(if(field_name=’Sent Email requesting showing instructions Mario ”really wants property” . – pss 11/25/11′, field_value, null )) AS ‘Sent Email requesting showing instructions Mario ”really wants property” . – pss 11/25/11’,
max(if(field_name=’Status’, field_value, null )) AS ‘Status’,
max(if(field_name=’property-address’, field_value, null )) AS ‘property-address’,
max(if(field_name=’listing-agent’, field_value, null )) AS ‘listing-agent’,
max(if(field_name=’agent-phone’, field_value, null )) AS ‘agent-phone’,
max(if(field_name=’agent-email’, field_value, null )) AS ‘agent-email’,
max(if(field_name=’Asst’, field_value, null )) AS ‘Asst’,
max(if(field_name=’Submit-Date’, field_value, null )) AS ‘Submit-Date’,
max(if(field_name=’List-Price’, field_value, null )) AS ‘List-Price’,
max(if(field_name=’Bid-Amount’, field_value, null )) AS ‘Bid-Amount’,
max(if(field_name=’Deposit-AMT’, field_value, null )) AS ‘Deposit-AMT’,
max(if(field_name=’follow-up-date’, field_value, null )) AS ‘follow-up-date’,
max(if(field_name=’Submitted From’, field_value, null )) AS ‘Submitted From’,
GROUP_CONCAT(if(file is null or length(file) = 0, null, field_name)) AS ‘fields_with_file’
FROM wp_cf7dbplugin_submits
WHERE form_name = ‘Untitled’
GROUP BY submit_time
ORDER BY submit_time DESC
LIMIT 0,100

The Bold is what I need to delete

where are the columns located at in the database? I think I found the issue. In the backend she had a bunch of nonsense columns created so I deleted most of them but it refuses to delete the remaining 3 bogus columns. So if I can locate these columns in the database and delete them that way it should be all good in the hood…

I dunno. My guess is, is that it is not in the database since I have already reverted twice to two previous versions. I’m lost…

SQL queries on database: SELECT * FROM wp_cf7dbplugin_submits WHERE 1

Fields:
submit_time
form_name
field_name
field_value
field_order
file

anyway, shouldn’t just reverting back to backed up sql enough? Why is this not fixing the issue?

so what I am going to attempt to do is go into the database and look for any suspicious records or tables and delete.

Im sorry, she accidentally hit the add column button and typed in info and clicked send and the error appeared…

here is line 325: foreach ($this->dataIterator->displayColumns as $aCol) {