Adult Script Pro Community Forums

racingjunky

Member

Registered: 2011-12-19

Posts: 25

Upgrade to 1.0.2

Hi i have some trouble with my upgrade.

Some Database Tables are not correkt

Query: SELECT duration, update_date FROM movuser_limit WHERE user_id = 11 LIMIT 1
Error Message: Table 'pornmovix.movuser_limit' doesn't exist
Error Number: 1146

i have fixed a other Problem before with the movvideo_history  and add view_date

Is there a actual database Stuktur were i can see what i have to correct.

racingjunky

Member

Registered: 2011-12-19

Posts: 25

Re: Upgrade to 1.0.2

I have test to insert the missed table but i dont know enough to set it right.

Let me know what i have to do.

Query: INSERT INTO movuser_limit SET user_id = 29, duration = , update_date = '2013-01-12'
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' update_date = '2013-01-12'' at line 3
Error Number: 1064

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: Upgrade to 1.0.2

From which version to which version did you upgrade?

---

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

racingjunky

Member

Registered: 2011-12-19

Posts: 25

Re: Upgrade to 1.0.2

Hi i have manualy update from1.0RC4 to 1.0.2  btw. 1.0.3 premium module

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: Upgrade to 1.0.2

Did you upgrade from 1.0RC4 to 1.0? Then 1.0 to 1.0.1? Then 1.0.1 to 1.0.2?

---

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

racingjunky

Member

Registered: 2011-12-19

Posts: 25

Re: Upgrade to 1.0.2

ja, have folowed your instruction.  but im not shure that I'm right.

racingjunky

Member

Registered: 2011-12-19

Posts: 25

Re: Upgrade to 1.0.2

i need only the filename who grap the database and the current TABLE structur from user_limit.

the rest i can fix by my self (i hope so)

thanks

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: Upgrade to 1.0.2

install/sqls/asp.sql

contains all the database tables. for user_limit:

CREATE TABLE `user_limit` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `duration` bigint(20) unsigned NOT NULL DEFAULT '0',
  `duration_total` bigint(20) unsigned NOT NULL DEFAULT '0',
  `update_date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

You can also disable user limit in Admin.

---

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

racingjunky

Member

Registered: 2011-12-19

Posts: 25

Re: Upgrade to 1.0.2

Hi, thanks.  it works.