Posts: 39
Threads: 8
Joined: Jan 2018
Reputation:
0
localhost db is Europe but server is in USA
i tried import db from localhost to live and getting>>> // any hint of solution???
Error
SQL query:
--
-- Database: `yyy`
--
-- --------------------------------------------------------
--
-- Table structure for table `activities`
--
CREATE TABLE `activities` (
`id` int(11) NOT NULL,
`resource_id` int(11) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`action` varchar(255) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said: Documentation
#1067 - Invalid default value for 'created_date'
Posts: 39
Threads: 8
Joined: Jan 2018
Reputation:
0
I DISABLED production mode ... and get:
An uncaught Exception was encountered
Type: RuntimeException
Message: Unable to locate the model you have specified: Subject_model
Filename: /home/lsepolis123/system/core/Loader.php
Line Number: 348
Backtrace:
File: /home/lsepolis123/public_html/index.php
Line: 321
Function: require_once
Posts: 39
Threads: 8
Joined: Jan 2018
Reputation:
0
/application
/system
/vendor
folders are out of /public_html one level up
Posts: 445
Threads: 6
Joined: Jun 2015
Reputation:
25
is the Subject_model.php in application/models?
Posts: 39
Threads: 8
Joined: Jan 2018
Reputation:
0
07-05-2018, 05:43 AM
(This post was last modified: 07-05-2018, 05:44 AM by lsepolis123.)
yes and is the first
I think sthg with model loading
any hint
???
autoload.php
$autoload['model'] = array('Subject_model', 'Activity_model', 'Video_model', 'User_model');
and another problem I can Not import Database from localhost to USA SERVER VPS
NEITHER WITH DATA NOR WITHOUT DATA
HAS ANYTHING DO WITH regional usa europe DATE...? In other words only name of database created in cPanel... in phpmyadmin can Not import...well?
Error
SQL query:
--
-- Database: `yyy`
--
-- --------------------------------------------------------
--
-- Table structure for table `activities`
--
CREATE TABLE `activities` (
`id` int(11) NOT NULL,
`resource_id` int(11) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`action` varchar(255) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said: Documentation
#1067 - Invalid default value for 'created_date'
Posts: 445
Threads: 6
Joined: Jun 2015
Reputation:
25
Subject_model.php or subject_model.php?
Posts: 39
Threads: 8
Joined: Jan 2018
Reputation:
0
yes but in lowercase all in the name... also localhost work with OUT ANY problems...