Mysql InnoDB and MyISAM in single database
I have database, where I have InnoDB and MyISAM tables. (InnoDB for PK a FK and MyISAM for fulltext indexes). On localhost everything works like a charm, but on endora webhosting (I have premium account) I'm getting this error when I'm trying to search.
[2015-07-07 18-59-36] PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'trwcaeprojectmanagement.searchProjects' doesn't exist in /home/users/lubossuk/caejab.8u.cz/web/vendor/nette/database/src/Database/ResultSet.php:68 @ http://caejab.8u.cz/www/search/search?w … mit=Search @@ exception-2015-07-07-18-59-36-fc34eacf91f6a41f05fa4aaaba2bb24d.html
Have someone experienced this problem?
yep my bad mistake. Realy it was just capital P. Im feel so stupid.
This looks like an issue with "case sensitivity" in table names.
It looks like table names are case sensitive in your web hosting environment, but not case sensitive on your localhost.
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. This convention is recommended for maximum portability and ease of use.
- How to return NULL when result is empty?
- Extract dirname from full path stored in database
- Using larger than or equal (>=) to in PreparedStatement in Java
- What is the difference between count(0), count(1).. and count(*) in mySQL/SQL?
- Convert a SELECT query containing two WHERE conditions to CodeIgniter's active record syntax
- How to find the minimum of a sum of values based on a distinct value?
- How to use 'and' with 'on' condition of joins in knex
- MYSQL Update query, replace part string containing URL
- CodeIgniter SELECT query to find rows with qualifying sets of column values in a JOINed table
- can we delete wp_woocommerce_sessions from database?
- NodeJS/mySQL - ER_ACCESS_DENIED_ERROR Access denied for user 'root'@'localhost' (using password: YES)
- Fast page retrieval in MySQL, index usage?
- MySQL Not Equal To Certain Length
- Problem connecting springboot to mysql with docker-compose
- Laravel Paginate with OrderByRaw return different order
- How to update a database using a loop?
- mysql2 Segmentation fault at 0x0000000000000000
- Retrieve query results as dict in SQLAlchemy
- How to do paging of pictures in PHP
- How to make a relation between two tables without foreign key
- How to pass password from file to mysql command?
- SQL - Columns merge and grouping by column name while summation of the other column
- A hackerrank sql challenge
- MySql Leap Years
- how to prevent mysql from createing mysql-bin.00000x files?
- Data truncation: Data too long for column 'logo' at row 1
- Count number of query results in a CodeIgniter application
- Convert raw MySQL containing a JOIN on identical column names and a WHERE and ORDER BY clause to CodeIgniter active record
- How to create MySQL function to update database if a value reaches 800?
- Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]