MTDb - Ultimate Movie&TV Database

MTDb - Ultimate Movie&TV Database v3.2.4 - Patch Update

No permission to download

helpicon

Member
May 6, 2019
60
19
8
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c1_mtdb_db.roles' doesn't exist (SQL: select * from `roles` where `guests` = 1 limit 1)
 

uranio89

Active member
Sep 21, 2019
108
35
28
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'description' in 'field list' (SQL: update `roles` set `description` = ?, `type` = sitewide, `image` = ?, `roles`.`updated_at` = 2020-08-01 09:35
 

dixoqut

Member
Jul 16, 2020
44
11
8
Hi
I run this script for a few weeks, but the problem is that browse page contents that are sorted by popularity doesn't change at all. here is my website:
Caasdpture.JPG
here is TMDb popular movies:
Caasdpdasdture.JPG
as you can see the arrangement doesn't the same, what should i do?
 

djjogy

Member
Aug 22, 2019
89
68
18
depends on the mysql query how it was created for year,name,popular,ratings, etc etc ORDER BY in MySQL: DESC & ASC. is not always the same with other scripts.

mtdb 3.1.4 and 3.2 and 3.2.1 the sorts are to be seen differently
i am still using MTDb v2.9.4
with a self written php upload script to 3.2 which synchronizes the mysql database to v2.9.4 and 3.1.4

which also makes an update from the database to 3.1.4 and 2.9.4
 
Last edited:

dixoqut

Member
Jul 16, 2020
44
11
8
i am on 3.2.2
can i do sync with tmdb manually?
something else: i added priority to servers but it ignore them and play the server that i added last. what should i do about that?
 

djjogy

Member
Aug 22, 2019
89
68
18
i am on 3.2.2
can i do sync with tmdb manually?
something else: i added priority to servers but it ignore them and play the server that i added last. what should i do about that?
wait a moment upload just video as example comes immediately
don't even realize that 3.2.2 already exists

because you only query via an API and no direct sql connection to tmdb
this is normal if you link tmdb and mtdb to one. This is not possible because the database queries of tmdb and mtdb are different. The mtdb had to write its own query which is now different from the query of tmdb. So a 1:1 is only possible if you have access to the database of tmdb. But Vebto does not have it^^
 
Last edited:
  • Like
Reactions: marcote and dixoqut

marcote

New member
Aug 10, 2020
17
0
1
hello, also an error in CSS GRID, because if you open the page in a scan of a smart tv it looks deformed. could someone verify that tbn?
 

djjogy

Member
Aug 22, 2019
89
68
18
MTDB 3.2.2 All Page Back to Up Button code
Go in Admin Settings
>>Custom HTML & Javascript<< NOT CSS
Insert this code have fun

Code:
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript">var scrolltotop={setting:{startline:100,scrollto:0,scrollduration:1e3,fadeduration:[500,100]},controlHTML:'<img src="https://abload.de/img/arrow5251jjh.png" />',controlattrs:{offsetx:25,offsety:25},anchorkeyword:"#top",state:{isvisible:!1,shouldvisible:!1},scrollup:function(){this.cssfixedsupport||this.$control.css({opacity:0});var t=isNaN(this.setting.scrollto)?this.setting.scrollto:parseInt(this.setting.scrollto);t="string"==typeof t&&1==jQuery("#"+t).length?jQuery("#"+t).offset().top:0,this.$body.animate({scrollTop:t},this.setting.scrollduration)},keepfixed:function(){var t=jQuery(window),o=t.scrollLeft()+t.width()-this.$control.width()-this.controlattrs.offsetx,s=t.scrollTop()+t.height()-this.$control.height()-this.controlattrs.offsety;this.$control.css({left:o+"px",top:s+"px"})},togglecontrol:function(){var t=jQuery(window).scrollTop();this.cssfixedsupport||this.keepfixed(),this.state.shouldvisible=t>=this.setting.startline?!0:!1,this.state.shouldvisible&&!this.state.isvisible?(this.$control.stop().animate({opacity:1},this.setting.fadeduration[0]),this.state.isvisible=!0):0==this.state.shouldvisible&&this.state.isvisible&&(this.$control.stop().animate({opacity:0},this.setting.fadeduration[1]),this.state.isvisible=!1)},init:function(){jQuery(document).ready(function(t){var o=scrolltotop,s=document.all;o.cssfixedsupport=!s||s&&"CSS1Compat"==document.compatMode&&window.XMLHttpRequest,o.$body=t(window.opera?"CSS1Compat"==document.compatMode?"html":"body":"html,body"),o.$control=t('<div id="topcontrol">'+o.controlHTML+"</div>").css({position:o.cssfixedsupport?"fixed":"absolute",bottom:o.controlattrs.offsety,right:o.controlattrs.offsetx,opacity:0,cursor:"pointer"}).attr({title:"Scroll to Top"}).click(function(){return o.scrollup(),!1}).appendTo("body"),document.all&&!window.XMLHttpRequest&&""!=o.$control.text()&&o.$control.css({width:o.$control.width()}),o.togglecontrol(),t('a[href="'+o.anchorkeyword+'"]').click(function(){return o.scrollup(),!1}),t(window).bind("scroll resize",function(t){o.togglecontrol()})})}};scrolltotop.init();</script>

<style>
#theme topcontrol {
position: fixed; 
bottom: 25px; 
right: 25px; 
opacity: 1; 
cursor: pointer;
}
</style>
 
Last edited:

djjogy

Member
Aug 22, 2019
89
68
18
hi guys, how i can edit mail templates in 3.2.2?


Here Can you mail templates in 3.2.2 edited
# Client

This project was generated with [Angular CLI](https://github.com/angular/angular-cli) version 6.1.5.

## Development server

Run `ng serve` for a dev server. Navigate to `http://localhost:4200/`. The app will automatically reload if you change any of the source files.

## Code scaffolding

Run `ng generate component component-name` to generate a new component. You can also use `ng generate directive|pipe|service|class|guard|interface|enum|module`.

## Build

Run `ng build` to build the project. The build artifacts will be stored in the `dist/` directory. Use the `--prod` flag for a production build.

## Running unit tests

Run `ng test` to execute the unit tests via [Karma](https://karma-runner.github.io).

## Running end-to-end tests

Run `ng e2e` to execute the end-to-end tests via [Protractor](http://www.protractortest.org/).

## Further help

To get more help on the Angular CLI use `ng help` or go check out the [Angular CLI README](https://github.com/angular/angular-cli/blob/master/README.md).

AND HERE INFO


have fun ;)
 

tazos

New member
Oct 31, 2019
15
3
3
tazosview.com
hi guys, how to make it like this without having to register as admin.
thank you.

Untitled.png

this is without login

Untitled2.png
 
Last edited:

sadek101

New member
Jun 13, 2020
1
0
1
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'description' in 'field list' (SQL: update `roles` set `description` = ?, `type` = sitewide, `image` = ?, `roles`.`updated_at` = 2020-08-01 09:35

Same problem here bro,.... Did you been able to fix it?
 

djjogy

Member
Aug 22, 2019
89
68
18
uranio89 said:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'description' in 'field list' (SQL: update `roles` set `description` = ?, `type` = sitewide, `image` = ?, `roles`.`updated_at` = 2020-08-01 09:35


update database
Code:
ALTER TABLE roles
ADD COLUMN description text CHARACTER SET utf8mb4;
 

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

User Menu