Database error undefined index sql_structure_or_data

bj3782

• May 30, 2017 07:14

I am experiencing a database error when trying to export files from my database using phpMyAdmin. When viewing the database I want to export from, it comes up with a red box at the top that reads: "Some errors have been detected on the server! Please look at the bottom of this window." And several blue boxes at the bottom that read: "Undefined index: sql_structure_or_data". See below... 47103 I was exporting files a couple of months ago and it was working fine. I haven"t made any significant changes since then so I"m not sure why the exporting is not working now. I've also had the max_input_vars error warning me that it has more than 1000 fields. When I tried to export the database, it would only download a 1 kb file without any fields in it. From replies to another thread in the forum, it looks like a new update might fix that error though. Question is, is the undefined index error caused by the max_input_vars error? Or is something else going on that is causing the problem? Thanks ahead of time!

• 

  cPanelMichael

  • May 30, 2017 18:16

  Question is, is the undefined index error caused by the max_input_vars error? Or is something else going on that is causing the problem?

  
  Hello, Could you verify which version of cPanel is installed on the system? You can check with the following command:
  cat /usr/local/cpanel/version
  cPanel version 64.0.24 addresses the max_input_vars error message with the following case: Fixed case CPANEL-12822: Bump max_input_vars to 10000 for phpMyAdmin. Thank you.

  0
• 

  bj3782

  • May 30, 2017 21:22

  I'm on 64.0.22. I'm a reseller and unfortunately am not in control of updating cPanel. The hosting company told me that cPanel automatically updates when 64.0.24 pushed to the stable tier. Do you know when that'll be? Also, is the undefined index error simply part of the max_vars_input error? I'm not sure if they'll both be resolved by the update or if I need to be looking for another solution to the undefined index error. Is there anything I can do with limited control as a reseller before 64.0.24 is pushed to stable tier? Thanks heaps!

  0
• 

  cPanelMichael

  • May 31, 2017 15:13

  Hello @bj3782, 64.0.24 was published to the STABLE build tier today. Automatic updates occur when the "upcp" cron job runs on the server, so the server should update to this version within 24 hours if your hosting provider has enabled automatic updates.

  Also, is the undefined index error simply part of the max_vars_input error? I'm not sure if they'll both be resolved by the update or if I need to be looking for another solution to the undefined index error.

  
  It's possible the error message is related to this value, however I recommend checking this again after the server your reseller account is hosted on is updated to 64.0.24 to see if the issue persists. Thanks!

  0
• 

  bj3782

  • June 01, 2017 05:22

  It has been updated to 64.0.24 now and both errors seem to be gone. Really appreciate the help, thanks!

  0
• 

  cPanelMichael

  • June 01, 2017 16:49

  I'm glad to see that helped. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.