We use cookies to help make our site work properly and to analyze how our site is used. Some are optional, but none contain your personal information, and we don't use any for ads. You can view our cookies policy, manage your cookie preferences, or consent and dismiss this banner by clicking agree:

Agree
ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Tabel exp_weblog_data, phpMyAdmin Problem

February 27, 2008 10:45am

Subscribe [1]

  • #1 / Feb 27, 2008 10:45am

    Erdal Demirtas

    84 posts

    Hi,

    I imported some entries to EE from my current application.
    Import is successful I can see and edit the entries via EE-CP. During this I wanted to control the data also with phpMyAdmin. After editing a default EE-entry I got the following errorlog entry (The same happens with the other new entries):

    [Wed Feb 27 14:33:08 2008] [error] [client XYZ] ALERT - 
configured request variable total name length limit exceeded - dropped 
variable 
'rows_to_delete[+`exp_weblog_data`.`entry_id`+=+1+AND+`exp_weblog_data`.`site_id`+=+1+AND+`exp_weblog_data`.`weblog_id`+=+1+AND+CONVERT(`exp_weblog_data`.`field_id_1`+USING+utf8)+=+''+AND+CONVERT(`exp_weblog_data`.`field_ft_1`+USING+utf8)+=+'xhtml'+AND+CONVERT(`exp_weblog_data`.`field_id_2`+USING+utf8)+=+'tThank+you+for+choosing+ExpressionEngine!+This+entry+contains+helpful+resources+to+help+you+<a+href="http://expressionengine.com/docs/overview/get_most.html">get+the+most+from+ExpressionEngine</a>+and+the+EllisLab+Community.+rnrnt[b]Technical+Support:[/b]rnrntAll+tech+support+is+handled+through+our+Community+forums.+Our+staff+and+the+community+respond+to+issues+in+a+timely+manner.+Please+review+the+<a+href="http://expressionengine.com/docs/overview/getting_help.html">Getting+Help</a>+section+of+the+User+Guide+before+posting+in+the+forums.rnrnt[b]Learning+resources:[/b]rnrnt<a+href="http://expressionengine.com/docs/overview/">Getting+Started+Guide</a>rnt<a+href="http://expressionengine.com/docs/quick_start/">Quick+Start+Tutorial</a>rnt<a+href="http://expressionengine.com/tutorials/">Video+Tutorials</a>rnrnt[b]Additional+Support+Resources:[/b]rnrnt<a+href="http://expressionengine.com/docs/">ExpressionEngine+User+Guide</a>rnt<a+href="http://expressionengine.com/knowledge_base/">Knowledge+Base</a>rnt<a+href="http://expressionengine.com/wiki/">ExpressionEngine+Wiki</a>rnrntIf+you+need+to+hire+a+web+developer+consider+our+<a+href="http://expressionengine.com/professionals/">Professionals+Network</a>.+You+can+also+place+an+ad+on+our+<a+href="http://ellislab.com/forums/viewforum/47/">Job+Board</a>+if+you+prefer+that+professionals+find+you.rnrntLove+ExpressionEngine?++Help+spread+the+word+and+make+some+spare+change+with+our+<a+href="http://expressionengine.com/affiliates/">Affiliates+program</a>.rnrntSee+you+on+the+boards,rnrnt[size=4]The+EllisLab+Team[/size]'+AND+CONVERT(`exp_weblog_data`.`field_ft_2`+USING+utf8)+=+'xhtml'+AND+CONVERT(`exp_weblog_data`.`field_id_3`+USING+utf8)+=+''+AND+CONVERT(`exp_weblog_data`.`field_ft_3`+USING+utf8)+=+'xhtml'+AND+`exp_weblog_data`.`field_id_4`+=+0+AND+CONVERT(`exp_weblog_data`.`field_ft_4`+USING+utf8)+=+'xhtml'+AND+`exp_weblog_data`.`field_id_5`+=+0+AND+CONVERT(`exp_weblog_data`.`field_ft_5`+USING+utf8)+=+'xhtml'+AND+`exp_weblog_data`.`field_id_6`+=+0+AND+CONVERT(`exp_weblog_data`.`field_ft_6`+USING+utf8)+=+'xhtml'+AND+`exp_weblog_data`.`field_id_7`+=+0+AND+CONVERT(`exp_weblog_data`.`field_ft_7`+USING+utf8)+=+'xhtml'+AND+`exp_weblog_data`.`field_id_8`+=+0+AND+CONVERT(`exp_weblog_data`.`field_ft_8`+USING+utf8)+=+'xhtml'+AND+CONVERT(`exp_weblog_data`.`field_id_9`+USING+utf8)+=+''+AND+CONVERT(`exp_weblog_data`.`field_ft_9`+USING+utf8)+=+'none'+AND+CONVERT(`exp_weblog_data`.`field_id_10`+USING+utf8)+=+''+AND+CONVERT(`exp_weblog_data`.`field_ft_10`+USING+utf8)+=+'none'+AND+CONVERT(`exp_weblog_data`.`field_id_11`+USING+utf8)+=+''+AND+CONVERT(`exp_weblog_data`.`field_ft_11`+USING+utf8)+=+'none'+AND+CONVERT(`exp_weblog_data`.`field_id_12`+USING+utf8)+=+''+AND+CONVERT(`exp_weblog_data`.`field_ft_12`+USING+utf8)+=+'none'+AND, 
referer: ./sql.php?db=db1053328-nn&token=d1590f74c43fc575f39b0b565d63c90b&table=exp_weblog_data&goto=tbl_structure.php

    After looking at what really happens, I saw that phpMyAdmin needs a primary key for a hidden field in the Edit page.

    <input type="hidden" name="primary_key[]" value="..." />


    The exp_weblog_data has no primary key but 3 indexes. As a result phpmyadmin writes all the fields of the entry in his hidden field and this seems to be a problem for the configuration: [...configured request variable total name length limit exceeded - dropped variable ...]

    Can i change the entry_id field of the exp_weblog_data as Primary Key?

    Is there any reason not to have a Primary Key for the table “exp_weblog_data”?

    Thanks!

  • #2 / Feb 27, 2008 11:01am

    Robin Sowell

    13255 posts

    I swear I’d seen this before, but a search here and on google turned up nada.  I’d almost expect it’s something quirky with phpmyadmin.  Not all tables will have a primary key.  I can’t spot why it would be a problem to make entry_id one in the exp_weblog_data table- but you shouldn’t NEED to do it.

  • #3 / Feb 27, 2008 11:18am

    Erdal Demirtas

    84 posts

    Thank you for the answer.
    Personally I didn’t also see any problem to make this field Primary Key.

    I have been using phpMyAdmin for a very yery long time like millions of other.
    I think it is better to able to use it also in the future.
    I also have Navicat but somehow I am using mostly phpMyAdmin.

    So if making this field Primary Key will solve the problem for using phpMyAdmin, I will do it.
    Of course if I dont’t use it, it doesn’t need to be done.

    In my case I am using phpMyAdmin in connection with EE mostly for editing and seeing how different characters from different languages are stored in DB.

  • #4 / Feb 27, 2008 11:28am

    Robin Sowell

    13255 posts

    I’m still thinking it’s something unique- I just pulled up one of my sites and edited a record in exp_weblog_data no problem- double checked, no primary key assigned.

    So it’s a little odd you’d need to specify a primary key to edit via phpmyadmin.

  • #5 / Feb 27, 2008 11:41am

    Erdal Demirtas

    84 posts

    FYI

    WITHOUT Primary Key:
    phpMyAdmin - 2.8.2.1 :
    Display, Edit OK but Save (Update) doesn’t function, and you have an entry in the errorlog.
    phpMyAdmin - 2.11.4
    Display, Edit, Save (Update) is OK, but you have an ALERT entry in the Errorlog.

    And the whole process is really very slow.

    WITH Primary Key:
    phpMyAdmin - 2.8.2.1, phpMyAdmin - 2.11.4 :
    Display, Edit, Save (Update) is OK, no entry in the Errorlog. Everthing is OK.

    And the process is not slow.


    ErrorLogs can be a real problem.
    The Host-Companies doesn’t like such things if you have shared hosting as I have now.

  • #6 / Feb 27, 2008 12:04pm

    Paul Burdick

    480 posts

    We do not support the manipulation of site data via phpMyAdmin, nor do we recommend modifying the underlying database structure of ExpressionEngine, so I am moving this thread into the How To forum as it falls outside normal support.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases

© Packet Tide, All Rights Reserved. Legal Notices

Username

Password

Forgot password?
or Register