Rukovoditel Support Forum

Error SQL query: Copy ALTER TABLE `app_fields` ADD` forms_rows_position` VARCHAR (255) NOT NULL AFTER `comments_forms_tabs_id` MySQL returned the message: Documentation # 1060 - Duplicate column name 'forms_rows_position It's not help. I uploaded the database backup and it's doesn't help too. After ...

After update all files and database i get this: Database Error: 1146 - Table 'database_name.app_forms_rows' doesn't exist Query: select f.*, fr.sort_order as form_rows_sort_order,right(f.forms_rows_position,1) as forms_rows_pos from app_fields f left join app_forms_rows fr on fr.id=LEFT(f.forms_rows...

ok, but we use at the same time another (old) crm system and there is no problem. The same amount of customers, the same operations, same server (another database) etc...

Info from hosting company (google translate): I kindly inform you that the administrator "hosting company name" blocked access to the xxxx database on the xxxx server. The hosting platform shares the server's hardware resources between many users, for whom "hosting company name" ...

4 users max in the same time

Ok, but it's happening every day even though the import took place only once and it was 3 days ago

Our hosting company every day blocking rukovoditel database. Only one think we did before that. We import 2000 customers. The database is very simple, name, address etc.. After that I get form hosting support information about server overload. We have download limit up to 100 000 000 records per day...

OK. - I think I did it. You have to create new filed and choose formula (as the field type) In my case I had to copy working sql query and change "static customer id" to the choosen customer id automaticly selected from table. See below: SELECT max(FROM_UNIXTIME(app_entity_54.date_added,'%...

Hi, I have two tables: Clients (parent table) and conversation (sub table). My goal is to print the max date (date_added) from conversation with customer in parent table. It's possible ? If yes how to do it ? below my sql working query : SELECT max(FROM_UNIXTIME(app_entity_54.date_added,'%Y-%m-%d'))...