Click here to Skip to main content
14,237,256 members
   

Database

 
GeneralRe: MySQL Pin
Member 1437004615-May-19 20:24
memberMember 1437004615-May-19 20:24 
GeneralRe: MySQL Pin
Richard MacCutchan15-May-19 21:17
protectorRichard MacCutchan15-May-19 21:17 
GeneralRe: MySQL Pin
Member 1437004615-May-19 20:25
memberMember 1437004615-May-19 20:25 
GeneralRe: MySQL Pin
Richard MacCutchan15-May-19 21:18
protectorRichard MacCutchan15-May-19 21:18 
QuestionMySql vs MariaDB Pin
DerekTP12315-May-19 1:25
professionalDerekTP12315-May-19 1:25 
AnswerRe: MySql vs MariaDB Pin
Richard MacCutchan15-May-19 3:15
protectorRichard MacCutchan15-May-19 3:15 
AnswerRe: MySql vs MariaDB Pin
jschell18-May-19 7:18
memberjschell18-May-19 7:18 
GeneralRe: MySql vs MariaDB Pin
DerekTP12319-May-19 7:23
professionalDerekTP12319-May-19 7:23 
Thanks, JSchell. I later found that although my apps were generally working OK, a couple of functions were failing. Digging deeper I found the issue was that on one StoredProc there was a "missing" parameter, and another was just missing altogether. Everything else was fine. I deduce from this that once alerted to the issue, they probably realised they'd forgotten to migrate the SPs and did a quick manual copy/paste. It's not a huge hosting company and although they have a few hundred databases, I suspect only a handful - or fewer - are using SPs so they may not even have been aware until I pointed out the issue.

They previously (last October) migrated to a new server op.system plus MySql upgrade. That also broke most of my sites since many call webservices on other domains, and the new server didn't support some of the older security protocols the sites were using. It was a one-line fix for each but took quite a while to identify. Also I couldn't send any emails via the SMTP server; I reported it and they claimed nothing had changed, but magically it started working about 10 minutes after I raised the ticket. Seriously p***ed off with them. They've given me a year's free hosting as compensation but when they continually break sites by screwing up upgrades (with no advance warning) I'd rather pay someone to do a proper job.... Frown | :(
GeneralRe: MySql vs MariaDB Pin
jschell23-May-19 5:29
memberjschell23-May-19 5:29 
GeneralRe: MySql vs MariaDB Pin
DerekTP12323-May-19 8:22
professionalDerekTP12323-May-19 8:22 
GeneralRe: MySql vs MariaDB Pin
jschell2-Jun-19 8:36
memberjschell2-Jun-19 8:36 
QuestionWhat is an alias? Pin
Shraddha_Patel7-May-19 18:20
memberShraddha_Patel7-May-19 18:20 
AnswerRe: What is an alias? Pin
Richard MacCutchan7-May-19 21:23
protectorRichard MacCutchan7-May-19 21:23 
AnswerRe: What is an alias? Pin
#realJSOP28-May-19 1:52
mve#realJSOP28-May-19 1:52 
QuestionHow can you get the alternate records from the table in the SQL? Pin
Shraddha_Patel30-Apr-19 22:53
memberShraddha_Patel30-Apr-19 22:53 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
Richard MacCutchan30-Apr-19 23:07
protectorRichard MacCutchan30-Apr-19 23:07 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
CHill601-May-19 5:05
protectorCHill601-May-19 5:05 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
Santosh kumar Pithani4-May-19 2:31
professionalSantosh kumar Pithani4-May-19 2:31 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
CHill6014-May-19 2:30
protectorCHill6014-May-19 2:30 
SuggestionRe: How can you get the alternate records from the table in the SQL? Pin
Richard Deeming14-May-19 2:38
mveRichard Deeming14-May-19 2:38 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
CHill6015-May-19 2:36
protectorCHill6015-May-19 2:36 
JokeRe: How can you get the alternate records from the table in the SQL? Pin
Richard Deeming15-May-19 6:51
mveRichard Deeming15-May-19 6:51 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
Santosh kumar Pithani15-May-19 20:43
professionalSantosh kumar Pithani15-May-19 20:43 
QuestionA strange issue!The count of queries does not match data. Pin
Member 1409322316-Apr-19 23:17
memberMember 1409322316-Apr-19 23:17 
AnswerRe: A strange issue!The count of queries does not match data. Pin
Maciej Los16-Apr-19 23:34
protectorMaciej Los16-Apr-19 23:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.