Database table names case sensitivity

Question

i got this script and trying to install it, but i am having problem: Here is the image:

Here is database.php file:

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
$active_group = 'default';
$query_builder = TRUE;
$db['default'] = array(
    'dsn'   => '',
    'hostname' => '*****',
    'username' => '******',
    'password' => '*******',
    'database' => '********',
    'dbdriver' => 'mysql',
    'dbprefix' => 'WS_',
    'pconnect' => TRUE,
    'db_debug' => TRUE,
    'cache_on' => FALSE,
    'cachedir' => 'application/cache/others',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '{PRE}',
    'autoinit' => TRUE,
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

There is database created and i imported this file that came up with the theme:

http://www.speedyshare.com/VNSkW/base.sql

I can't figure out where is problem i am not that good at php, if you need any other files i will upload them and post here.

Here is web link: http://chwallpapers.cf/

PS: My english is bad, sry.

Are you sure that table WS_wallpapers is in your database? — u_mulder
– u_mulder, Commented Dec 22, 2015 at 19:53
Try to use wc_wallpapers, maybe table names are case sensitive. — u_mulder
– u_mulder, Commented Dec 22, 2015 at 19:57
Yea works now, thanks bro i was trying to figure out this for a long time. — user4606459
– user4606459, Commented Dec 22, 2015 at 20:02

u_mulder · Accepted Answer · 2015-12-22 20:17:34Z

3

As we found out - table names can be case sensitive.

And even mysql warns about it:

This means database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix.

Full text, for example, here

So your query should be rewritten to use ws_wallpapers instead of WS_wallpapers

edited Dec 22, 2015 at 20:17

answered Dec 22, 2015 at 20:07

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database table names case sensitivity

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related