DB Duplicate Entry Error

  • Resolved Brian P

    (@bburgay)


    5 years, 10 months ago

    Log constantly filled with:

    WordPress database error Duplicate entry ‘0-0’ for key ‘PRIMARY’ for query INSERT INTO wp_adsPage (PageID,IP,Time,Count) VALUE(0,’0′,1547631558,1)

    This is coming from adswsc_DbInstall. It’s comparing the table names “wp_adspage” and “wp_adsPage” which aren’t equal so trying to create the table constantly.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Anonymous User 8804248

    (@anonymized-8804248)

    Hi, thank you for send a message.

    Now i cant find an error, the db name is used with a constant, never change upper to lower case on my code. table name is on create allways with upper and lower case into database inserted.

    sorry.

    Thread Starter Brian P

    (@bburgay)

    Hi Andrew,

    I looked into this more and this is only an issue on Windows (I’m getting the errors when running locally on my windows machine only). I checked the live site and the table does have the uppercase P. On windows the uppercase is not allowed unless we change settings so the table gets created as wp_adspage instead of wp_adsPage.

    I would consider getting rid of the camel case as it could be an issue on windows servers and I’ve never seen a wp table use camel case. Just a thought.

    Thanks,
    Brian

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB Duplicate Entry Error’ is closed to new replies.