Thread

I am developing a site locally, using MAMP on a Mac with EE 1.6.7. The problem occurs both when using Safari or Firefox.
I have imported about a 100 records via CSVGrab (this may or may not be to do with my problem).
Whenever I turn on any extension, and then try to switch to the Edit Page, or try to edit a specific weblog entry, all I get is a blank page.
I have been working with most extensions switched off, but I am getting to the point where I need to investigate this.
The only extensions I have currently on without a problem are:
Admin Section With Tabs!  (v.1.0.1)
Clone Entries (v.1.1)

As soon as I turn on any other extension (e.g. Edit Menu, EEvent Helper), the problem occurs.
So I have done some preliminary investigations:
When I use the SQL Manager to browse tables, all the tables are OK, except the same blank page occurs when trying to browse:
exp_weblog_data   Browse   124   220.6 KB

So my guess is something happened on importing those weblog entries via CSVGrab that interfered with the storage of that data. It could be that this occurs when some javascript functions are involved ??
I had a similar problem before when I was experimenting months ago on a completely different set of data and CSVGrab.

Can you recommend some steps to isolate the error ? Anything else I can do ?

Thanks for any help.

Michael
PS: I posted the same problem yesterday under extensions, but did not get any responses, as I’m presenting it rather vaguely and without much concrete evidence, I guess.

Just to make sure, this has got to do with extensions? It’s working fine without any? Yes, it definitely might be an issue with CSVGrab.

Is there a particular reason why you’re using 1.6.7? We recommend to use 1.6.8 for all new sites.

Thanks for your response.
The delay in getting back to you now is that I have now switched over to 1.6.8.
My problems are definitely related to extensions - when I disable all of them, it works fine.
I have spent hours trying to isolate the offending one, but the results are inconclusive.
It is now working with a minimum set after I have disabled the following (which in principle I’d like to use):
Edit Menu (v.1.0.2)
Edit Tab AJAX (v.1.2.2)
FieldFrame (v.1.3.4)
Low Seg2Cat (v.1.0.2)
MD Live Search (v.1.2.1)
File, by Mark Huot (v.3.1.1)
REEOrder (v.1.0)
Selected Items (v.1.3)

That minimum set includes:
Admin Section With Tabs!  (v.1.0.1)
Clone Entries (v.1.1)
EEvent Helper (v.1.1)
User (v.2.0.8)

What’s my next steps ? Thanks so much for your help.
Michael

Hi Michael,

Even with the minimum set of extensions are you still able to browse the exp_weblog_data table in the SQL Manager?

Cheers

Greg

Even with the minimum set of extensions are you still able to browse the exp_weblog_data table in the SQL Manager?

As far as I’m aware, even when the problem IS occurring, I can always access that table - the database never seemed to be corrupted according to SQL Manager (although I have used it to repair and optimize the tables). But I don’t think throughout my hours of struggles with this there was ever a report of an error in SQL Manager.

Does that help us a step further ?

Thanks for sticking with me on this

Michael

You have inspected the database table row by row to discern any anomalies?
Have you tried to delete the data and reimport it with CSV Grab?
Deleted the data and checked to see if you have the same problem with remaining data in EE?
Deleted the data and entered some identical entries manually?
Restored an earlier backed-up version of the database, if you have it, and then imported the data fresh with CSV Grab?
Reinstalled EE itself and repeated the import again to a fresh site with next-to-nil extensions?
Then, where appropriate and things are ‘working’, adding back extensions one-by-one, checking results?

I’m not being snarky, just thinking of some things I might try, not necessarily in priority order.

You have inspected the database table row by row to discern any anomalies?
Have you tried to delete the data and reimport it with CSV Grab?
Deleted the data and checked to see if you have the same problem with remaining data in EE?
Deleted the data and entered some identical entries manually?
Restored an earlier backed-up version of the database, if you have it, and then imported the data fresh with CSV Grab?
Reinstalled EE itself and repeated the import again to a fresh site with next-to-nil extensions?
Then, where appropriate and things are ‘working’, adding back extensions one-by-one, checking results?

Yes, I have, within reason. I tried the whole process on a clean install several times, importing the data immediately after setting up the necessary custom fields. Then, after the error occurred, deleting the entries and re-importing. Since I had this problem working in 1.6.7, I have now switched to 1.6.8, with a full set of extensions working on manually entered entries. I then imported again and spent a good time experimenting with turning extensions on one by one. You can gather, I have been busy with this for days.
What has been difficult is that the conclusions from turning extensions on and off have been so inconclusive and results have been intermittent. Sometimes, when I later turn on an extension that previously seemed to ‘cause’ the error and I had switched it off, then later seemed to work fine. So I can’t seem to pin it down. I got so fed up with it, that I have now built the site from scratch, beginning to enter the data manually by copying and pasting, and even without CSVGrab the error has occurred.
So my money is on a conflict between extensions, I’m just wondering what set of extensions and versions other people have working together nicely. And I have a hunch that it is something to do with Javascript .... but these are all just guesses.

Any other ideas ?

Michael

Hi Michael,

Please ensure that in Output & Debugging (CP Home > Admin > System Preferences > Output and Debugging Preferences > Debug Preference) you have option 1 (PHP/SQL errors shown only to Super Admins) selected. This may provide a clue to the exact error. Additionally, does your host allow you access to the server error logs for your site? If so, can you please review them when you suffer this error and let me know if there is an error message?

Cheers

Greg

I now have some additional information:
I have found an error in a database table - the one relating to html buttons.
I was trying to create some (in My Account - Weblog Settings) beyond the standard 4, and every time I get to creating button 9, the blank screen appears. I have looked into the table, and this is what it shows:

116     1     1     <h2>     <h2>     </h2><p>     2     6     1<br />
115     1     1     <h1>     <h1>     </h1>     1     5     1<br />
114     1     1     <bq>    </p><blockquote><p>    </p>
</blockquote><p>     q     4     1<br />
113     1     1     <u>     <u>     </u>     u     3     1<br />
112     1     1     <i>     <i>     </i>     i     2     1<br />
111     1     1     <b>     <b>     </b>     b     1     1<br />
117     1     1    </p><h3>     <h3>     </h3><p>     3     7     1<br />
118     1     1    </p><h4>     <h4>     </h4>     4     8     1

I have repaired that table OK, but can’t get past button 8. I don’t understand the id numbers 111 to 118 - could they be conflicting with something else ?
Can I import that html button table from another installation, or will that make matters worse (currently I am the only member of the site) ?
Any help much appreciated

Michael

Hi Michael,

That data looks ok. What are you trying to add as button number 9?

Cheers

Greg

I’m off to work now, so just briefly to keep this going .... I experimented last night with adding more buttons, both for myself as a member, plus I created another member and was trying to add buttons for their account. Invariably, on submitting button 8 (for example h4), the page goes blank. I press the back-button in the browser and get back to the account page for editing html buttons and it then only shows the first 4 buttons.
It does look like there is some corruption of data, but maybe it’s not in that table, but it conflicts with another table ??

Thanks for your help.

Michael

I don’t understand the id numbers 111 to 118 - could they be conflicting with something else ?

No, but they are rather high. I have 1-9 in there.

Can I import that html button table from another installation, or will that make matters worse (currently I am the only member of the site)?

Yes, you can certainly try that. Just be sure to keep good & reliable backups at all times.

Thanks for your response, Ingmar.
This is really difficult to pin down. Miraculously, after ignoring the html buttons ad having giving up on fiddling with extensions, they started working and I added some more for member 1, some more default buttons (member_id 0 in the table), and some more for a second member I created.
As everything was working smoothly, I thought I’d try turning on - one by one - some of the disabled extensions. If I enable either Field Frame or MD Live Search, it seems to create the problem that in my Account Page under Weblog Settings, I cannot access the html buttons, but only get a blank page.

Does that help us any further in identifying the issue ?

Thanks again

Michael

If I enable either Field Frame or MD Live Search, it seems to create the problem that in my Account Page under Weblog Settings, I cannot access the html buttons, but only get a blank page.

Are you quote sure we can pin it down to either of these two extensions? In other words, does it work as expected without them?

That is a definite ‘Yes’. If I turn either of them on, I get the blank page on trying to access the html buttons.
I have checked the html button table, and no errors are reported there in SQL Manager, and this is the data (which still looks OK to me, except for the high id numbers):

211    1    2    <b>    <b>    </b>    b    1    1
212    1    2    <bq>    <blockquote>    </blockquote>    q    2    1
213    1    2    <del>    <del>    </del>    d    3    1
214    1    2    <i>    <i>    </i>    i    4    1
215    1    2    <u>    <u>    </u>    u    5    1
216    1    2    <h1>    <h1>    </h1>    1    6    1
217    1    2    <h2>    <h2>    </h2><p>    2    7    1<br />
218    1    2    </p><h3>    <h3>    </h3><p>    3    8    1<br />
219    1    2    </p><h4>    <h4>    </h4><p>    4    9    1<br />
256    1    0    <b>    <b>    </b>    b    1    1<br />
257    1    0    <bq>    </p><blockquote><p>    </p>
</blockquote><p>    q    2    1<br />
258    1    0    <del>    <del>    </del>    d    3    1<br />
259    1    0    <i>    <i>    </i>    i    4    1<br />
260    1    0    <u>    <u>    </u>    u    5    1<br />
261    1    0    <h1>    <h1>    </h1>    1    6    1<br />
262    1    0    </p><h2>    <h2>    </h2><p>    2    7    1<br />
273    1    1    <b>    <b>    </b>    b    1    1<br />
274    1    1    <bq>    </p><blockquote><p>    </p>
</blockquote><p>    q    2    1<br />
275    1    1    <del>    <del>    </del>    d    3    1<br />
276    1    1    <i>    <i>    </i>    i    4    1<br />
277    1    1    <u>    <u>    </u>    u    5    1<br />
278    1    1    <h1>    <h1>    </h1>    1    6    1<br />
279    1    1    </p><h2>    <h2>    </h2><p>    2    7    1<br />
280    1    1    </p><h3>    <h3>    </h3><p>    3    8    1<br />
281    1    1    </p><h4>    <h4>    </h4><p>    4    9    1<br />
282    1    1    flt_table    <div><table><tr><td><b>heading</b><ul><li>item 1</li><li>item 2</li><li>item 3</li></ul></td></tr></table>    </div>    f    10    1

Thanks

Michael