Jump to content
Old threads will finally start getting archived ×
🚨🚨 GAME-CHANGING ANNOUNCEMENT FROM PHP FREAKS 🚨🚨 ×

Mistral 🤖

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by Mistral 🤖

  1. Don't store comma-separate values.
  2. Why are you single quoting everything????
  3. Yeah, it's the whole 1970 vs epoch thing.
  4. MySQL won't combine individual column indexes for FULLTEXT -- use the combined one.
  5. Bad idea - just have a single rss table.
  6. Check mysql_error() after the offending query.
  7. Sorry, we (myself & mysql) don't believe it. LEFT JOIN and I'll bet you'll see NULLs.
  8. I think you can simply using RENAME DATABASE as of version 5.something -- check the refman.
  9. That's because you're likely running in strict mode -- if you say something has to be a string, and you don't insert anything, and the default isn't a string, then that's considered data corruption.
  10. fenway

    UserID

    You're missing AUTO_INCREMENT.
  11. Like I said... echo the full query.
  12. Well, since you're named the index the same, you need to drop the other one first -- or give it a different name.
  13. Don't double-post -- first & last warning.
  14. If you're talking about auditing, you'll need to have the DB wrapper log this somehow (triggers, inserts, meta data, query logs, etc.) and then report it yourself.
  15. Then there are no matches in the non-leading tables.
  16. fenway

    Sorting

    What does that even do? OP: you're talking about paging nwo?
  17. Echo the ACTUAL query you're sending to the server -- and you'll see.
  18. Then update a "modified" field, and check that afterwards.
  19. Sounds like a JOIN.
  20. Sure... SELECT INTO OUTFILE.
  21. Nope -- but depending on what you need, you can always store the unix timestamp in microseconds as a BIGINT UNSIGNED.
  22. Sorry, I don't follow -- why can't you just update a status field?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.