mysql DB errors

  • warning: Creating default object from empty value in /home/webapp/drupal-6.28/sites/all/modules/advanced_forum/advanced_forum.module on line 492.
  • warning: Creating default object from empty value in /home/webapp/drupal-6.28/sites/all/modules/advanced_forum/advanced_forum.module on line 492.
3 replies [Last post]
Thu, 2010-10-14 14:06
Anonymous

Hi,

i'm trying to set up a tigase with mysql database. When i try to start the server i get several errors:

2010-10-14 14:35:12 ConfiguratorAbstract.setProperties() SEVERE: Can't initialize auth repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:mysql://myserver.net:3306/tigase?user=user&password=password
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:433)
at tigase.db.RepositoryFactory.getAuthRepository(RepositoryFactory.java:123)
...

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION tigase.TigGetDBProperty does not exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
....

I did follow the steps described here: http://www.tigase.org/content/prepare-mysql-database-tigase-server

As i understand the problem tigase tries to use a stored procedure that isn't there.

I hope you can help me fix that.

Top
Thu, 2010-10-14 14:38
#1
kobit's picture
Artur Hefczyc
Offline
Joined: 2006-09-03
Points: 267814

Please check the guide again at the step 3. You probably loaded the old schema for the version 4 or earlier. I assume you are using the most recent Tigase version 5.x, then you need to load db schema-4 which includes required stored procedures.

Top
Thu, 2010-10-14 15:05
#2
AlexanderB (not verified)

SQL-Befehl:

-- QUERY END:
-- QUERY START:
-- Database properties get - function
CREATE FUNCTION TigGetDBProperty(
_tkey varchar( 255 ) CHARSET utf8
) RETURNS mediumtext CHARSET utf8READS SQL DATA BEGIN declare _result mediumtext CHARSET utf8;

MySQL meldet: Dokumentation
#1064 - 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 '' at line 1

i can't import the file....

Top
Thu, 2010-10-14 15:27
#3
AlexanderB (not verified)

reply to myself. after checking everything twice i had a little discussion with our db admins. no stored procedures for our database....

Top

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.