Error: Error executing query: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alloc.can_edit_rate does not exist Error: Query failed: 42000 1305 SELECT can_edit_rate(1,0) as allow

[Wally]

Hi, restored db after some maintenance [ mysql alloc < allocbak.sql ] and am now getting below error, have I not got some functions captured and then restored in my backup?

Backed up using mysqldump alloc > allocbak.sql

Thanks.

Error: Error executing query: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alloc.can_edit_rate does not exist
Error: Query failed: 42000 1305 SELECT can_edit_rate(1,0) as allow

[Alex Lance]

The procedures/functions that are a part of the alloc database didn't get backed up when you used mysqldump. Use --routines when dumping, or just manually reimport the installation/db_triggers.sql file that is in the alloc source code. It is safe to just reimport that one file.

Cheers,
Alex Lance
allocPSA.com

[Wally]

Thanks for yor quick response Alex!

Got this

ERROR 1146 (42S02) at line 1043: Table 'alloc.reminder' doesn't exist

[Alex Lance]

Hi Wally, no worries. Is there a reminder table? Does your backup/dump file have a reminder table in it?

[Wally]

Yes it did.
What worked was this sequence, first load structure, triggers, constraints, then my dump.

Love allocPSA, thanks for your great work it is marvelous.

[Alex Lance]

Ah cheers, good stuff. Thank you!