ERROR 1064 (42000) at line 2606 (astbill 0.9.0.4)

By Lab Mousee at Wed, 2005-10-05 20:08 | AstBill Software - General and Support

# mysql -p****** astbill < /home/astbill-0.9.0.4/database/astbill.sql

ERROR 1064 (42000) at line 2606: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `asv_friend` AS select `ast' at line 1

any idea why?

Asterisk is controlled by

By mrktlr on Mon, 2009-08-31 05:17

Asterisk is controlled by editing a set of configuration files. One of these, extensions.conf, contains the dialplan and controls the operational flow of Asterisk. A native scripting language is used to define the elements of process control, namely named variables, procedural macros, contexts, extensions, and actions. A context groups all the valid destination numbering codes which apply to a set of channels on which incoming (to Asterisk) calls can be presented. These numbering codes, called “extensions” (even though they often are not) are the starting points for the scripts which instruct Asterisk how to process calls made to those numbers within that context.

___________________________________________________________________
web hosting | domain registration | dedicated servers

» login or register to post comments

tirger.sql

By Lab Mousee on Wed, 2005-10-05 20:11

also, what happened to the astbill_triger.sql file?

» login or register to post comments

astbill_triger.sql

By london3 on Thu, 2005-10-06 15:54

The trigger file is not needed anymore. The trigger defination is part of the astbill.sql file.

MySQL is now exporting triggers when you do a mysqldump of a database. This was not the issue in the earlier release of MySQL 5.

I guess changes are part of the cost of developing on a Beta Database. But now MySQL 5.013 is EXELENT and extreemly stabel.

ARE --

» login or register to post comments

anyone?

By Lab Mousee on Thu, 2005-10-06 09:30

anyone?

» login or register to post comments

redo database from scratch

By rchurch on Thu, 2005-10-06 16:06

I think it may be advisable to reinitialise your database from scratch and check all your settings.

I upgraded my database from mysql 4, and I couldn't insert accounts until I run mysql_fix_privilege_tables and gave the astbill use execute rights.

On looking at the code that line appears to be in a comment, unless it a new escape code in MySQL I don't know about.

A GUI tool that show better error codes may help, like phpmyadmin, aqua studio or sqlyog

» login or register to post comments

Mysql 5.013

By Lab Mousee on Fri, 2005-10-07 01:14

Upgrading to mysql 5.013 fixed the problem :) yey!

» login or register to post comments