search

uepg / laravel-sybase

Connection and Laravel Eloquent driver for Sybase
GNU General Public License v2.0
33 stars 16 forks source link

I work with Laravel 6.x, Models dosnt work. #63

Closed ConsSorto closed 4 years ago

ConsSorto commented 4 years ago

Hello i work with this package, the conection is fine, but the models dosnt work. i try to use a USER Model but when i create a new user the project show this error :

SQLSTATE[HY000]: General error: 20018 SQL Anywhere Error -852: Table name 'syscolumns' is ambiguous [20018] (severity 16) [ SELECT a.name, st.name AS type FROM syscolumns a, systypes b, systypes s, systypes st WHERE a.usertype = b.usertype AND s.usertype = a.usertype AND s.type = st.type AND st.name NOT IN ( 'timestamp', 'sysname', 'longsysname', 'nchar', 'nvarchar' ) AND st.usertype < 100 AND object_name (a.id) = 'users'] (SQL: select count(*) as aggregate from [users] where [email] = jhon@coofe.com)

nunomazer commented 4 years ago

Hi @Cons28, can you try it with a Laravel 5.8 version? And see if the error persist? I'll only have some time to work on this package at feb/2020 because of holidays

ConsSorto commented 4 years ago

Hello i try with a laravel 5.8 and the error persist :

SQLSTATE[HY000]: General error: 20018 SQL Anywhere Error -852: Table name 'syscolumns' is ambiguous [20018] (severity 16) [ SELECT a.name, st.name AS type FROM syscolumns a, systypes b, systypes s, systypes st WHERE a.usertype = b.usertype AND s.usertype = a.usertype AND s.type = st.type AND st.name NOT IN ( 'timestamp', 'sysname', 'longsysname', 'nchar', 'nvarchar' ) AND st.usertype < 100 AND object_name (a.id) = 'users'] (SQL: select count(*) as aggregate from [users] where [email] = jhon@coofe.com)

mainginski commented 4 years ago

@Cons28 Try use yourdatabase..tablename in $table var on Model.

nunomazer commented 4 years ago

Closing since no feedback was given by @Cons28