Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

#1 2013-11-24 16:53:02

mario2000
Member
From: Spain
Registered: 2012-05-04
Posts: 190
Website

Import mysql from 5.1.70 to 5.5.32

Hi

Y have change the server:
Old server: mysql 5.1.70
New server: mysql 5.5.32
---------------------------
After import the old DB I get blank pages (all pages)

I need to know if this new version of mysql is suported by ASpro, and how i can make working the old db in the new server.

Thanks


Brutal Porn Videos - Brutal5.org
Peliculas Online - PepeCine
Filme Online Romana - Filme5

Offline

#2 2013-11-25 10:05:17

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Import mysql from 5.1.70 to 5.5.32

Its 100% supported. I always use the latest version when i work on ASP. Currently i'm using:

[symtab@mybox ~]$ mysql --version
mysql  Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 5.1
[symtab@mybox ~]$ 

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2013-11-27 23:36:18

mario2000
Member
From: Spain
Registered: 2012-05-04
Posts: 190
Website

Re: Import mysql from 5.1.70 to 5.5.32

Thanks, but if you import the old 5.1 to other server with 5.5 , you get some errors.
I have created an new DB and i have copy and paste all tables content (just content)
-------------------------------
Also, in the old DB structure i have this `wmuser_comments`:
INSERT INTO `wmuser_comments` (`comment_id`, `parent_id`, `user_id`, `poster_id`, `ip`, `comment`, `add_date`, `status`, `spam`, `nickname`) VALUES
----------
the last column `nickname` - is mising in the 1.0.8 (new install)

I dont know if is an error, or not (all work ok), is mor for simtab, if have forget to add this column in the 1.0.8 instaler.


Brutal Porn Videos - Brutal5.org
Peliculas Online - PepeCine
Filme Online Romana - Filme5

Offline

#4 2013-11-29 12:56:39

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Import mysql from 5.1.70 to 5.5.32

Its a bug. I will fix it in 1.0.9. Its missing from the sql file.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#5 2013-11-29 13:36:16

mario2000
Member
From: Spain
Registered: 2012-05-04
Posts: 190
Website

Re: Import mysql from 5.1.70 to 5.5.32

So I have to add this mising column by adding the entire table?

--
-- Estructura de tabla para la tabla `wmuser_comments`
--

CREATE TABLE IF NOT EXISTS `wmuser_comments` (
  `comment_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `poster_id` int(11) unsigned NOT NULL DEFAULT '0',
  `ip` int(10) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `add_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `spam` int(11) unsigned NOT NULL DEFAULT '0',
  `nickname` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`comment_id`),
  KEY `parent_id` (`parent_id`),
  KEY `user_id` (`user_id`),
  KEY `poster_id` (`poster_id`),
  KEY `ip` (`ip`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=83 ;

Brutal Porn Videos - Brutal5.org
Peliculas Online - PepeCine
Filme Online Romana - Filme5

Offline

#6 2013-11-29 13:40:53

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Import mysql from 5.1.70 to 5.5.32

You can do:

ALTER TABLE `wmuser_comments` ADD `nickname` varchar(100) NOT NULL DEFAULT '';

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#7 2013-11-29 13:59:16

mario2000
Member
From: Spain
Registered: 2012-05-04
Posts: 190
Website

Re: Import mysql from 5.1.70 to 5.5.32

Thanks, I will do this.


Brutal Porn Videos - Brutal5.org
Peliculas Online - PepeCine
Filme Online Romana - Filme5

Offline

Board footer

Powered by FluxBB