ThemeKings Custom Web Design
"Old School Web Design Community Forum"

Author Topic: 1089 Error in MYPHPADMIN when creating Database for Shoutbox  (Read 493 times)

Offline Swift

  • Administrator
  • Newbie
  • *****
  • Posts: 24
  • Web Developer
    • View Profile
    • ThemeKings
1089 Error in MYPHPADMIN when creating Database for Shoutbox
« on: February 04, 2022, 11:36:51 AM »
Please reference this video for the workaround. This is not my video, but they do a great job showing how to get around the 1089 error when selecting the primary option in the Index column for the ID.

In his video his column with primary is called roll_num. Just ignore that as we are calling ours ID and setting it to be our primary for this shoutbox.

The error occurs when you go to save the database after you've created the 4 columns.

After you save, you'll get the error message. Close that error window and then "Preview SQL" so that you can copy all that code it displays.

Next, open the "SQL" tab above and then remove/replace that code with the code you just copied.

Now remove the number and the parenthesis surrounding it that follows the ID. (Again ours will be called ID but in his video its labeled roll_num.)

Lastly, hit GO to save. BOOM! Your done!

Watch 1089 Fix Video
Credit: Mad ProgrammerRPS
« Last Edit: February 05, 2022, 11:08:24 AM by Swift »
Todd Swift
Web Developer