1. Hercules bug tracker archive
  2. Hercules Bug Archives
  3. Core
  4. Missing SQL DB entrys

Missing SQL DB entrys

Issue information

Issue ID
#7817
Status
Fixed
Severity
None
Started
ossi0110
Nov 10, 2013 14:07
Last Post
Haru
Nov 15, 2013 14:43
Confirmation
N/A

ossi0110 - Nov 10, 2013 14:07

like allways , you missed to update the .sql files for itemdbs . getting tons of warnings from the sql DB , running PRE-RE mode


since the commit from Haruna with casesensitive


[url="https://github.com/HerculesWS/Hercules/commit/b4f1b3b5c5c009ed4f7635c5349ea97c80c08c25"]https://github.com/HerculesWS/Hercules/commit/b4f1b3b5c5c009ed4f7635c5349ea97c80c08c25[/url]

This post has been edited by ossi0110 on Nov 10, 2013 14:09

Haru - Nov 10, 2013 15:06

You're right, sql files are out of sync again, my fault :(

I do not have the necessary software to update those files (they were created with the db2sql plugin, and then exported through phpmyadmin, which I consider an awful piece of software and refuse to install - mysqldump produces a different output and I'd need to postprocess it in order to minimize the diff and maintain the same format)

We're planning (and already have some working code) to let the HerculesWSAPI bot commit the sql updates just like it commits the hooks updates. Until that is ready or someone (Ind?) can push an update, you can use the db2sql plugin yourself as a workaround.

Zezicla - Nov 12, 2013 10:26

+1

Haru - Nov 15, 2013 14:43

The SQL database is now up to date