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.

#2 Re: Troubleshooting » Moved to new server » 2013-03-20 19:25:23

BUT..........

Now getting this when trying to upload via ftp.........

Query: UPDATE video SET ext = 'flv', size = , duration = 0, thumbs = 0, mobile = '0', server = 0, s3 = 0, status = 7 WHERE video_id = 64 LIMIT 1
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 ' duration = 0, thum' at line 3
Error Number: 1064

It says "check the manual"
mmmm Is there one ??

#3 Re: Troubleshooting » Moved to new server » 2013-03-20 19:22:46

Hi

Its ok its now fixed

Problem was "lighttpd"  server fixed it

#4 Troubleshooting » Moved to new server » 2013-03-20 17:19:33

amateur56
Replies: 3

Hi

We have moved all our sites to another server.

But now it cant find any videoas/streams..

What do I need to change to get this working

Finds embed videos but not ones I uploaded myself, although they are there on server.

Thanks

George

#5 Re: Troubleshooting » Error » 2012-11-18 00:23:10

Sent mail via your profile

#6 Troubleshooting » Error » 2012-11-17 14:18:52

amateur56
Replies: 2

Hi Anyone

1st I dont know how to find out what ver I'm on as it was done by adrian pity it dont just show you at bottom of page somewhere?
I have this file in the install folder so I guess Im on 1.0
upgrade-1.0rc4-to-1.0.php

Questions .....

1)...

When Im in the PHOTOS section and click a photo to view it large I get the below error - Ive emailed adrian a few times but no reply for ages
weve never been able to get a stable ver to run so cant go live yet its so frestrating.

Query: SELECT c.comment_id, c.parent_id, c.user_id, c.comment, c.add_date, c.nickname, u.username, u.gender, u.avatar FROM photo_comments AS c LEFT JOIN user AS u ON (u.user_id = c.user_id) WHERE c.photo_id = 15 AND c.status = '1' ORDER BY c.comment_id DESC LIMIT 10
Error Message: Unknown column 'c.nickname' in 'field list'
Error Number: 1054

2)..  Also getting the below when clicking a video PREMIUM thumb 

Query: INSERT INTO video_history SET video_id = 20, user_id = 3, ip = 1543776426, view_date = '2012-11-17 03:11:57'
Error Message: Unknown column 'view_date' in 'field list'
Error Number: 1054

3)..  How do we purchase the ccbill payment modual? 

4)..  How do I upgrade to the newest stable ver as it only has upto 1.0 when running upgrade.php

Any help will do as were running blind here

#7 Re: Bug Reports » [FIXED] Error Message: Unknown column 'c.nickname' in 'field list' » 2012-08-31 23:45:28

so how do we upgrade to 1.0.1   or even 1.0.2 when it comes?

The last upgrade option is
Upgrade from RC4 to 1.0

wheres 1.0.1


I did send my info but its not been fixed

#9 Bug Reports » [FIXED] Error Message: Unknown column 'c.nickname' in 'field list' » 2012-08-06 09:51:55

amateur56
Replies: 7

Hi


I get the below when trying to view a photo
Query: SELECT c.comment_id, c.parent_id, c.user_id, c.comment, c.add_date, c.nickname, u.username, u.gender, u.avatar FROM photo_comments AS c LEFT JOIN user AS u ON (u.user_id = c.user_id) WHERE c.photo_id = 14 AND c.status = '1' ORDER BY c.comment_id DESC LIMIT 10
Error Message: Unknown column 'c.nickname' in 'field list'
Error Number: 1054

George

#10 Re: Troubleshooting » Mass Video FTP Upload not work? » 2012-02-28 20:45:00

I guess you've never had a chance to check this yet as its still the same?

#11 Re: Troubleshooting » Mass Video FTP Upload not work? » 2012-02-23 08:05:42

Adrian did you get my email with info on as you've not replied to say so and its still not working?

I can upload photo via the admin though just not via site.


New error now....
Cant add model photo via admin now


George

#12 Re: Troubleshooting » Mass Video FTP Upload not work? » 2012-02-18 13:26:27

1.  NO progress bar

3. Ah gee Ive been looking for weeks for that smile

ALSO... just tried the upload photos (not mass)  and theres no progress bar there either so cant upload photos now either?

#13 Troubleshooting » Mass Video FTP Upload not work? » 2012-02-18 10:30:49

amateur56
Replies: 6

Hi

I'm just trying to work my way around this program a bit at a time really to see what each menu actually does a bit of a trial and error.

I have a few question I need answered.

1) Mass Video FTP Upload - I uploaded to ftp - tried the Mass Video FTP Upload it finds the files but after pressing the submit button it does nothing

2) When I do get it working, do I delete the files in the upload folder on ftp or leave them?

3) Once Ive made a video "premium"  how can I "UNpremium" it ?   theres no link to to such a thing?

maybe enough for now I will defo have more smile

George

Board footer

Powered by FluxBB