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-02-13 04:17:44

pxoxrxn
Member
Registered: 2011-12-01
Posts: 67
Website

Inserting new table?

Hi, I just upgraded to 1.0.6 and I thought I did it correctly, but I guess now. Eveything is working good but when I go to upload a file, both FTP and upload. I get the following error message and no videos upload.

Query: INSERT INTO pornvideo_orig SET video_id = 370, user_id = 1, filename = 'DirtyJess.avi', ext = 'avi', size = 10314882, method = 'upload_file', url = '', ip = ******, add_time = 1360727880
Error Message: Table 'pxoxrxn.pornvideo_orig' doesn't exist
Error Number: 1146

To fix the problem, I think I need to add the table pornvideo_orig, however, I am not sure of to do this or what the structure of this table should be.

Could someone please let me know how to do this?

Cheers

Offline

#2 2013-02-13 04:59:59

pxoxrxn
Member
Registered: 2011-12-01
Posts: 67
Website

Re: Inserting new table?

I fixed the problem. If anyone else has this problem, here is how you fix it.

go to phpmyadmin
click your database
Scroll to the bottom and insert a table with 9 columns and call it whatever you need to, in this case it will be called video_orig
add each of the required fields.
video_id
user_id
filename
ext
size
method
url
ip
add_time

If I have done this wrong, please correct me. However, this has worked fine.

Offline

#3 2013-02-13 06:54:12

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

Re: Inserting new table?

The table was added in 1.0.3.


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

Offline

#4 2013-02-13 08:07:45

pxoxrxn
Member
Registered: 2011-12-01
Posts: 67
Website

Re: Inserting new table?

Yeah, somehow I managed to break it.

Offline

Board footer

Powered by FluxBB