updated database

View previous topic View next topic Go down

updated database

Post by rollster on Fri Aug 05, 2011 9:44 pm

When attempting to update database:

SQL query:


ALTER TABLE `movies` DROP INDEX `hash` ,
ADD INDEX `hash` ( `hash` ( 1 ) ) ;




MySQL said:



#1091 - Can't DROP 'hash'; check that column/key exists



As well alt.links table is non-existent.

Thanks

rollster

Posts : 30
Kudos : 731
Trust : 0
Join date : 2011-07-19

View user profile

Back to top Go down

Re: updated database

Post by rollster on Fri Aug 05, 2011 9:58 pm

I noticed that you can get it from centralized area but not sure it's working correctly. I let it sit there for a bit and it never refreshed stating it was successful.

rollster

Posts : 30
Kudos : 731
Trust : 0
Join date : 2011-07-19

View user profile

Back to top Go down

Re: updated database

Post by rollster on Fri Aug 05, 2011 10:33 pm

never mind...I checked in the /core/database and it was there.

rollster

Posts : 30
Kudos : 731
Trust : 0
Join date : 2011-07-19

View user profile

Back to top Go down

Re: updated database

Post by rollster on Fri Aug 05, 2011 11:32 pm

Could I somehow get an updated movie database.

rollster

Posts : 30
Kudos : 731
Trust : 0
Join date : 2011-07-19

View user profile

Back to top Go down

Re: updated database

Post by rollster on Fri Aug 05, 2011 11:39 pm

I noticed that since I used the July 31 database in centralised area, I only show 231 TV Shows as opposed to 379 on the demo site.


I still seem to be having issues with movies section...not sure what is going on there...I am attempting to try a few things to see if they work out.


Is it possible to get a more recent database?

rollster

Posts : 30
Kudos : 731
Trust : 0
Join date : 2011-07-19

View user profile

Back to top Go down

Re: updated database

Post by rollster on Sat Aug 06, 2011 3:51 pm

I decided to wipe out all movies and pull them all again.

rollster

Posts : 30
Kudos : 731
Trust : 0
Join date : 2011-07-19

View user profile

Back to top Go down

Re: updated database

Post by rollster on Sat Aug 06, 2011 3:53 pm

still having issues with some pics not showing up...they are being saved in the images/movies folder, but when you check the jpg it tells you it is corrupt. Still getting &8211 kinda stuff in titles as well. Whatever movie or tv show that has this in the title, you are unable to click on it.

It is also not pulling tags...ie adventure,comedy,erotic, etc nor is it able to pull description for some reason when scrapping for movies. I re-uploaded all scrapper files and still not working 100% for me.

rollster

Posts : 30
Kudos : 731
Trust : 0
Join date : 2011-07-19

View user profile

Back to top Go down

Re: updated database

Post by Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum