Everything disappears when I attempt an insert.

Muscycle

• January 21, 2022 22:31

I created a table wherein the only difference from all the others is it has a BLOB column. When I attempt an insert using the phpMyAdmin interface boxes (instead of writing the SQL myself), worse than nothing happens: the screen goes to the root login page. No error messages or anything! I figured something went awry with the table so I dropped and recreated it.... same result. This thing is acting like it has a mind of its own. Can anyone help me sort this out? 1song_id alt="Primary">http://localhost/phpmyadmin/themes/dot.gif
int(11)NoNoneAUTO_INCREMENThttp://localhost/phpmyadmin/themes/dot.gif
2song_name varchar(50) utf8mb4_general_ciNoNone 3song_file blob Media type: application/octetstreamNoNonehttp://localhost/phpmyadmin/themes/dot.gif
4genre_id alt="Index">http://localhost/phpmyadmin/themes/dot.gif
int(11) NoNonehttp://localhost/phpmyadmin/themes/dot.gif
5music_maker_id alt="Index">http://localhost/phpmyadmin/themes/dot.gif
int(11) NoNonehttp://localhost/phpmyadmin/themes/dot.gif
6song_date date No current_timestamp()http://localhost/phpmyadmin/themes/dot.gif

• 

  cPRex Jurassic Moderator

  • January 24, 2022 21:56

  Hey there! Let me see if I'm testing this right. I made a database with the following table with a Blob type: mysql> CREATE TABLE example1 (ID SMALLINT UNSIGNED, Name VARCHAR(40), Description BLOB);
  Confirmed that was created correctly: mysql> describe example1; +-------------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------------------+------+-----+---------+-------+ | ID | smallint(5) unsigned | YES | | NULL | | | Name | varchar(40) | YES | | NULL | | | Description | blob | YES | | NULL | | +-------------+----------------------+------+-----+---------+-------+ 3 rows in set (0.00 sec)
  Then I went to PHPMyAdmin and tried to do an import - by just adding the number "2" to my smallint field, and that input was accepted normally. Here is the output from that through the interface: INSERT INTO `example1` (`ID`, `Name`, `Description`) VALUES ('2', NULL, NULL);
  Would you happen to have root access to the server so you could check the MySQL logs and see if there was anything reported there during the issue?

  0
• 

  Muscycle

  • January 24, 2022 22:05

  I do have such access. When I insert just one field, an ID field, it goes OK. When I attempt to enter a file name into the BLOB field using PHPMyAdmin's "choose file" button is when I get the problem. Exactly which log should I check?

  0
• 

  cPRex Jurassic Moderator

  • January 24, 2022 22:26

  Ah, I didn't try inserting into the BLOB. I created a plain txt file and inserted that, and it worked how I would expect: INSERT INTO `example1` (`ID`, `Name`, `Description`) VALUES (NULL, NULL, NULL), (NULL, NULL, 0x7b5c727466315c616e73695c616e7369637067313235325c636f636f61727466323531330a5c636f636f61746578747363616c696e67305c636f636f61706c6174666f726d307b5c666f6e7474626c5c66305c6673776973735c6663686172736574302048656c7665746963613b7d0a7b5c636f6c6f7274626c3b5c7265643235355c677265656e3235355c626c75653235353b7d0a7b5c2a5c657870616e646564636f6c6f7274626c3b3b7d0a5c6d6172676c313434305c6d61726772313434305c766965777731303830305c7669657768383430305c766965776b696e64300a5c706172645c74783732305c7478313434305c7478323136305c7478323838305c7478333630305c7478343332305c7478353034305c7478353736305c7478363438305c7478373230305c7478373932305c7478383634305c7061726469726e61747572616c5c7061727469676874656e666163746f72300a0a5c66305c66733234205c6366302072616e646f6d20746578742066696c657d);
  By default, the MySQL log is located at /var/log/mysqld.log on cPanel systems, but that can be changed in the /etc/my.cnf configuration file. So if you don't see the file in /var/log, run this to get the correct file name: grep log-error /etc/my.cnf
  

  0
• 

  Muscycle

  • January 25, 2022 01:02

  There is a table in the MySQL database entitled, "General Log" but it has no data. I'm not using a cPanel system (at least I don't think so).-

  0
• 

  cPRex Jurassic Moderator

  • January 25, 2022 21:03

  The log wouldn't be inside a table, but a flat file somewhere on the server. It's odd that you're not using a cPanel machine if you're asking questions here on our forum, as this is designed specifically for cPanel users. However, I'd still expect PHPMyAdmin to behave the same on a non-cPanel machine.

  0
• 

  Muscycle

  • January 26, 2022 03:00

  My apologies, I thought this was a PHPMyAdmin forum.

  0
• 

  Muscycle

  • January 26, 2022 03:22

  I found the error log. But it isn't a jpeg. I have it as a pdf. It doesn't show any errors associated with the problem I've experienced.

  0
• 

  cPRex Jurassic Moderator

  • January 26, 2022 17:59

  Unfortunately I'm not sure - it could be PHPMyAdmin itself that is causing the error, so checking the log for that tool might be a good next step. If you're using a standard installation of PHPMyAdmin, open the tool but don't select any database and look for the Binary Log tab. You can then select different logs from a dropdown list and press the GO button to view them. I'm not sure where the PHPMyAdmin log would be on your machine, but one popular location is /var/www/html/phpMyAdmin-5.0.1-all-languages/log/ so you might want to see if you have that for issues with the software itself.

  0
• 

  Muscycle

  • January 28, 2022 04:00

  Thank you very much. I appreciate your input.

  0

Please sign in to leave a comment.