Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • in reply to: On Delete Action Lost On Foreign Key #35750
    ErikEgon
    Member

    Sure, this is what is reported:

     

    SQLYog: 12.2.4

    MySQL: 5.5.50-0ubuntu0.14.04.1

     

    I have seen this behavior more often over the past months (years?), but too lazy to report.

     

    Erik.

    in reply to: Viewing Tabledata In Utf8 #32985
    ErikEgon
    Member

    I've just sent it through the mail. The zip-file is very small: 1,798 bytes.

    in reply to: Viewing Tabledata In Utf8 #32982
    ErikEgon
    Member

    Sorry, lost the attachment, I think. Another try …

    in reply to: Viewing Tabledata In Utf8 #32981
    ErikEgon
    Member
    Quote:
    BTW: When you wrote “8. In MySQL the data is displayed as mentioned in the first post.” I think you meant “8. In *SQLyog* …” . Right? Did you try other clients?

    Yes, SQLyog was what I meant indeed. But I also checked this on the commandline using Putty a few minutes ago and the mysql client tool gives me the exact same results.

    I'd be more than happy to share. I think this is an issue that headaches not only me!

    Please find attach a zip file containing a very, very basic “index.php” that lets one insert records in a database and immediately displays the results. It also contains the test database containing the table and one example record.

    Regards,

    Erik.

    in reply to: Viewing Tabledata In Utf8 #32979
    ErikEgon
    Member

    Peter,

    When I dump the table on my local PC the data in the file shows, as you expected, two characters for a simple é.

    I thought that telling MySQL it should expect UTF-8 data it would accept and understand multibyte characters and store it as multibyte characters. And apparently, it does.

    So I would rather expect that I should create a SQLYog UTF-8 connection so that SQLYog would send UTF-8 data and accept and display UTF-8 data on return.

    Stil unsure if this is a situation that has a 100% satisfying answer: perhaps all my wishes just don't mix.

    Regards,

    Erik.

    in reply to: Viewing Tabledata In Utf8 #32978
    ErikEgon
    Member

    Hi Peter,

    Thank you for responding at such short notice. Still chewing in the information.

    Okay, so how do I go about when I need:

    1. A website where customers must leave personal data (first and lastnames with extended characters do happen)

    2. A database that supports extended characters (I need to store the data)

    3. An easy GUI like SQLYog to printout readable data when querying

    This is the setup:

    1. The webpage (meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″) is in UTF-8.

    2. I told the form (accept-charset=”utf-8″) it should send all entered data in UTF-8.

    3. I setup the PHP database connection using SET NAMES 'utf8'

    4. Created a test database with default characterset utf8

    5. Created a table with Character Set = utf8, Collation = utf8_general_ci

    6. All varchar columns are in Character Set = utf8, Collation = utf8_general_ci

    7. Retrieving previously entered data from the database is correctly displayed, without the help of any PHP function, in the test page.

    8. In MySQL the data is displayed as mentioned in the first post.

    What is wrong? If you could share any thoughts, it would be much appreciated, not just by me ….

    Never thought this was a MySQL bug …

    Happy new year!

    Erik.

    in reply to: Bug – Unable To Edit View #32391
    ErikEgon
    Member
    'peterlaursen' wrote:

    Not reproducible with this simple test case:

    CREATE TABLE k (a VARCHAR(20));

    CREATE TABLE l (b VARCHAR(20));

    CREATE VIEW m AS SELECT k.a, l.b FROM k,l;

    DROP TABLE k;

    SHOW CREATE VIEW m;

    Also the SQLyog GUI opens as it should from the view context-menu. But of course

    SELECT * FROM m;

    returns

    “Error Code : 1356

    View 'test.m' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them”

    This reacts (in the GUI, that is) exactly as you predicted.

    in reply to: Bug – Unable To Edit View #32390
    ErikEgon
    Member
    'peterlaursen' wrote:

    And also if you try to show data for the View in the GRID, SQLyog will execute “SHOW FULL FILEDS FROM from `test`.`m`” what returns the same error.

    Does not work. Am I looking at a wrongly installed mysql server?

    Query : SHOW FULL FILEDS FROM 'vgdagen2011.vw_organisatoren' 



    Error Code : 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 'FILEDS FROM 'vgdagen2011.vw_organisatoren'' at line 1



    Execution Time : 00:00:00:000

    Transfer Time : 00:00:00:000

    Total Time : 00:00:00:000

    in reply to: Bug – Unable To Edit View #32389
    ErikEgon
    Member

    When on the command-line this error appears:

    mysql> SHOW CREATE VIEW vw_organisatoren;

    ERROR 1356 (HY000): View 'vgdagen2011.vw_organisatoren' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

    This error is shown both for the owner of the schema/view and for root. No errors in the errorlogs on /var/log/mysql

    in reply to: Bug – Unable To Edit View #32386
    ErikEgon
    Member
    'peterlaursen' wrote:

    This is a server error (and probably a server bug). All 4-digit error messages starting with '1' are server errors. Just execute SHOW CREATE etc. with any client. You will get exactly the same error.

    You are right. I did this on an Ubuntu DEV server, 5.1.41-3ubuntu12.10. When I tried to reproduce this on a UAT environment at the hosting company I did NOT get any errors at all, just when browsing table data. They are using 5.0.90 (not sure what linux flavour they're on).

    Sorry for the BUG report. Mistake on my part. I'll have a look with the admin what is causing the error.

    Thanks for the quick reply, though!

Viewing 10 posts - 1 through 10 (of 10 total)