coderberg / residencecms Goto Github PK
View Code? Open in Web Editor NEWOpen Source Property Management System based on Symfony 7
License: MIT License
Open Source Property Management System based on Symfony 7
License: MIT License
If I create a new page I would like to place it in the menu where I like. Now it seems it has some default order.
It would be nice if the currency of a property is selectable, or if you can change the default currency system wide. Now it shows a dollar sign.
A stored cross-site scripting (XSS) vulnerability exists in ResidenceCMS 2.10.1 that allows a low-privilege user to create malicious property content with HTML inside it, which acts as a stored XSS payload. If this property page is visited by anyone including the administrator, then the XSS payload will be triggered.
Below is a simple step-by-step on how to reproduce the issue:
Sometimes a property is sold by different agents. It would be nice if you could select the agent on a per property basis.
Now it works like the one who creates the porperty is in fact the onwer. But I think it would be better if that is selectable.
Hi Coderberg,
It would be very nice if it was possible to upload more images at the same time. Really a time saver.
Tried to set it up locally
Migration 20181012133837 failed during Execution. Error An exception occurred while executing 'CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, full_name VARCHAR(255) NOT NULL, username VARCHAR(255) NOT NULL, phone VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, roles JSON NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'JSON NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_' at line 1
In AbstractMySQLDriver.php line 79:
An exception occurred while executing 'CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, full_name VARCHAR(255) NOT NULL, username VARCHAR(255) NOT NULL
, phone VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, roles JSON NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (user
name), UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve
rsion for the right syntax to use near 'JSON NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_' at line 1
In PDOConnection.php line 90:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve
rsion for the right syntax to use near 'JSON NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_' at line 1
In PDOConnection.php line 88:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve
rsion for the right syntax to use near 'JSON NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_' at line 1
Валерий здравствуйте. Прекрасная работа! Подскажи пожалуйста что нужно сделать, чтобы изображения, которые я загрузил к объекту недвижимости появились в слайдере к объявлению. Я загрузил несколько фото к объявлению, но они не показываются в слайдере и их нет при редактировании фото объявления. В тех объявлениях, что идут с установкой системы изображения присутствуют, но после добавления новых фото то их потом тоже нет. Или это пока не реализовано? В любом случае спасибо огромное за труды и успехов в проектах. Я первый раз поставил cms на symfony... очень впечатляет.
What would be the best way to add batch uploading of listings and photos?
I do not exactly undertsnad what the difference is and why this is useful. Maybe because I am in Spain :-) ?
I found problem, with cyrillic routes, eg. path/slug.
I will try to fix this and will make pull request.
Also, I will translate ResidenceCMS to Bulgarian and will make additional pull request for this.
Здравствуйте! MariaDB 10.3.29, но при установке выдает ошибку:
In AbstractMySQLDriver.php line 98:
An exception occurred while executing 'ALTER TABLE users RENAME INDEX uniq_8d93d649f85e0677 TO
UNIQ_1483A5E9F85E0677':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; c
heck the manual that corresponds to your MariaDB server version for the right syntax to use nea
r 'INDEX uniq_8d93d649f85e0677 TO UNIQ_1483A5E9F85E0677' at line 1
https://snipboard.io/JRTjOG.jpg
Какую версию необходимо использовать?
At the end of the migration, such errors were issued:
php bin/console doctrine:migrations:migrate
Migration 20191107180849 failed during Execution. Error An exception occurred wh ile executing 'ALTER TABLE area CHANGE city_id city_id INT NOT NULL':
SQLSTATE[HY000]: General error: 1832 Cannot change column 'city_id': used in a f oreign key constraint 'FK_D7943D6888823A92'
In AbstractMySQLDriver.php line 106:
An exception occurred while executing 'ALTER TABLE area CHANGE city_id city
_id INT NOT NULL':
SQLSTATE[HY000]: General error: 1832 Cannot change column 'city_id': used i
n a foreign key constraint 'FK_D7943D6888823A92'
In PDOConnection.php line 80:
SQLSTATE[HY000]: General error: 1832 Cannot change column 'city_id': used i
n a foreign key constraint 'FK_D7943D6888823A92'
In PDOConnection.php line 75:
SQLSTATE[HY000]: General error: 1832 Cannot change column 'city_id': used i
n a foreign key constraint 'FK_D7943D6888823A92'
php bin/console doctrine:fixtures:load
Careful, database "nptz" will be purged. Do you want to continue? (yes/no) [no]:
> yes
> purging database
In AbstractMySQLDriver.php line 42:
An exception occurred while executing 'DELETE FROM metro':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nptz.metro' doesn't exist
In PDOConnection.php line 43:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nptz.metro' doesn't exist
In PDOConnection.php line 41:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nptz.metro' doesn't exist
Since symfony/mailer is included in the package, I think this should be prefered to the swiftmailer package (which is also inlcuded).
Suggestion to rewrite the code to use symfony/mailer instead of swift_mailer
Hi Coderberg,
Really love this install. It has almost everything I need. Just curious what the plans are for the future?
Thanks for sharing this nice peace of work!
Hi Coderberg, in the code I can see you have anticipated on translations. If you like, I can take care of the dutch translation
Hi Coderberg,
It would be nice to explain in the readme how to upgrade from 1.3.2 to 1.3.3. I had to do a complete new install cause I did not know how.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.