Just a test !

[sendmesoon]

Hi,

I had an error after to have installed your script! Fuel\Core\Fuel_Exception [ Error ]: You have specify a valid path to store the session data files.

COREPATH/classes/session/file.php @ line 313

Can u to help me please?

Thx u Philippe

[mjsilva]

Hi Philippe,

It looks like FUEL is trying to start a session but the sessions file folder is not writable.

Please check this thread: http://fuelphp.com/forums/topics/view/3959

Basically in you config folder you should have a sessions file and inside should be the path to where FUEL is going to save the session files this path has to exists and be writable.

If you can't make it work please do tell me so I can dig it further.

Cheers, MJS

[sendmesoon]

hi Manuel,

I speak about writable folder, but for my test, i have a environement Windows with Wamp Server !! I don't need a writable right on widows system ! It's strange. Thx u for your help phy

[mjsilva]

Humm... never tried to run on Windows.

Change this line https://github.com/mjsilva/mjs.me/blob/master/fuel/app/config/session.php#L77 in your code to something that windows can write like for eg: c:\windows\temp

[sendmesoon]

Now it's ok with c:\TMP but new error:

COREPATH/classes/database/mysql/connection.php @ line 111 Do u have a sql script?

[sendmesoon]

ok i had a bad localhost: i just need a sql script because not table inside

[mjsilva]

Well you should run the migrations using "php oil migrate" in the command line.

Can you try and let me know if it runs on Windows?

ty

[sendmesoon]

i tested php oil migrate and i don't have any error in command line, but i have always this error: Fuel\Core\Database_Exception [ 1146 ]: Table 'tinyt.users' doesn't exist [ SELECT * FROM users WHERE username IS NULL ]

no tables :)

[sendmesoon]

it's ok thx u very much

[mjsilva]

You made it?

Anyway here's the schema, you might want to change the analytics code :P

# ************************************************************
# Sequel Pro SQL dump
# Version 3408
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 127.0.0.1 (MySQL 5.0.95)
# Database: mjs_me
# Generation Time: 2012-03-15 13:41:08 +0000
# ************************************************************

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

# Dump of table migration
# ------------------------------------------------------------

DROP TABLE IF EXISTS `migration`;

CREATE TABLE `migration` (
  `current` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

# Dump of table options
# ------------------------------------------------------------

DROP TABLE IF EXISTS `options`;

CREATE TABLE `options` (
  `id` int(11) NOT NULL auto_increment,
  `option_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `option_value` text character set utf8 collate utf8_unicode_ci,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;

INSERT INTO `options` (`id`, `option_name`, `option_value`)
VALUES
    (1,'public','1'),
    (2,'site_name','mjs.me'),
    (3,'site_title','Whoa! That\'s an huge URL you got there'),
    (4,'analytics_code','<script type=\"text/javascript\">\r\n\r\n  var _gaq = _gaq || [];\r\n  _gaq.push([\'_setAccount\', \'UA-7237856-10\']);\r\n  _gaq.push([\'_trackPageview\']);\r\n\r\n  (function() {\r\n    var ga = document.createElement(\'script\'); ga.type = \'text/javascript\'; ga.async = true;\r\n    ga.src = (\'https:\' == document.location.protocol ? \'https://ssl\' : \'http://www\') + \'.google-analytics.com/ga.js\';\r\n    var s = document.getElementsByTagName(\'script\')[0]; s.parentNode.insertBefore(ga, s);\r\n  })();\r\n\r\n</script>'),
    (5,'shorturl_driver','short'),
    (6,'shorturl_set','abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_'),
    (7,'shorturl_fixed_length','5');

/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;

# Dump of table url_tracking
# ------------------------------------------------------------

DROP TABLE IF EXISTS `url_tracking`;

CREATE TABLE `url_tracking` (
  `id` int(11) NOT NULL auto_increment,
  `short_url` varbinary(5) NOT NULL,
  `date_created` datetime NOT NULL,
  `ip_address` varchar(15) character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# Dump of table urls
# ------------------------------------------------------------

DROP TABLE IF EXISTS `urls`;

CREATE TABLE `urls` (
  `id` int(11) NOT NULL auto_increment,
  `short_url` varbinary(200) NOT NULL,
  `real_url` text character set utf8 collate utf8_unicode_ci,
  `date_created` datetime NOT NULL,
  `creator_ip_address` varchar(15) character set utf8 collate utf8_unicode_ci NOT NULL,
  `hits` int(100) NOT NULL default '0',
  `date_last_hit` datetime default NULL,
  `legacy` tinyint(1) NOT NULL default '0',
  `cookie_id` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
  `user_id` int(11) default NULL,
  PRIMARY KEY  (`id`,`short_url`),
  UNIQUE KEY `NewIndex1` (`short_url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,
  `password` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `email` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `last_login` varchar(25) character set utf8 collate utf8_unicode_ci default NULL,
  `login_hash` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `profile_fields` text character set utf8 collate utf8_unicode_ci,
  `group` int(11) default NULL,
  `api_key` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[sendmesoon]

Thx u manuel, I had run php oil migrate and it's work now without passed the sql script. So for your information, with windows system, u have to change the path session on "c:\YOUR_TMP_PATH" without right. Your code is good and well done!