Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - rocky

Pages: [1]
1
ThumbsPlus v10 Questions / Re: Thumbs 10 Pro - MySQL
« on: 2019-05-23 12:08:32 »
Thank you Daan!  That helped get it working, using the sql script on the TP website:
http://www.thumbsplus.com/binaries/database/new/Thumbs9_mysql.sql

The one from the zip file you posted didn't work. ThumbsPlus gave an error about it not being a ThumbsPlus database.

This is what I did.

Log into MariaDB terminal
Code: [Select]
$ mysql -u root -p
Set the mode
Code: [Select]
MariaDB [(none)]>  SET sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ANSI_QUOTES';
Load the script
Code: [Select]
MariaDB [(none)]>  source /path/to/Thumbs9_mysql.sql
Grant permission to a user to use the database
Code: [Select]
MariaDB [(none)]>  grant all privileges on ThumbsPlus.* to user@'%' identified by 'password';
Then set up an ODBC connection to the ip address of the machine using the above user/pass.

Seems to be working! Thanks for taking the time to post.



2
ThumbsPlus v10 Questions / Re: Thumbs 10 Pro - MySQL
« on: 2019-05-22 16:50:48 »
Hi I have the same problem. I have MariaDB running on a linux box.

I try loading the sql schema using this command found on your website http://www.thumbsplus.com/databases.html.
Code: [Select]
[rocky@server~]$ mysql -u root -p  < Thumbs9_mysql.sql
Results in this error.
Code: [Select]
ERROR 1064 (42000) at line 14: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"ThumbsPlus"' at line 1

Seems like it hates the double quotes, so I stripped them out of the entire script and run it again but then get this error.
Code: [Select]
ERROR 1064 (42000) at line 93: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(255) NOT NULL            ,
    value             longtext       NOT NULL' at line 4

I tried all kinds of syntax variations in that area of the script and can't figure out why it's throwing that error.

I can't find the thread entitled "TP7 w/ MySQL: Full instructions by PeteW1959" anywhere on your forum.

I can successfully connect to my MariaDB box through a 32 bit ODBC connection so I think I'm good as long as I can get the schema working.  Any help would be greatly appreciated. Thank you.


Pages: [1]