1. Illuminate\Database\QueryException – Internal Server Error SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘details_en’ in ‘INSERT INTO’ (Connection: mysql, SQL: insert into `smartend_sections` (`row_no`, `title_en`, `details_en`, `seo_title_en`, `seo_url_slug_en`, `title_hi`, `details_hi`, `seo_title_hi`, `seo_url_slug_hi`, `icon`, `webmaster_id`, `father_id`, `popup_id`, `visits`, `status`, `created_by`, `updated_at`, `created_at`) values (5, aaaa, , aaaa, aaaa, aaaa, , aaaa, aaaa, ?, 10, 0, ?, 0, 1, 1, 2025-12-08 09:56:00, 2025-12-08 09:56:00))

PHP 8.4.7 Laravel 12.30.1 emitra.co.in

1. Stack Trace

0 – vendor/laravel/framework/src/Illuminate/Database/Connection.php:824 1 – vendor/laravel/framework/src/Illuminate/Database/Connection.php:778 2 – vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php:42 3 – vendor/laravel/framework/src/Illuminate/Database/Query/Processors/MySqlProcessor.php:35 4 – vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3853 5 – vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:2235 6 – vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1436 7 – vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1401 8 – vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1240 9 – app/Http/Controllers/Dashboard/CategoriesController.php:129 10 – vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 11 – vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 12 – vendor/laravel/framework/src/Illuminate/Routing/Route.php:265 13 – vendor/laravel/framework/src/Illuminate/Routing/Route.php:211 14 – vendor/laravel/framework/src/Illuminate/Routing/Router.php:822 15 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 16 – app/Http/Middleware/LanguageSwitcher.php:22 17 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 18 – vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50 19 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 20 – vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php:63 21 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 22 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:87 23 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 24 – vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:48 25 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 26 – vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:120 27 – vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 28 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 29 – vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36 30 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 31 – vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:74 32 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 33 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137 34 – vendor/laravel/framework/src/Illuminate/Routing/Router.php:821 35 – vendor/laravel/framework/src/Illuminate/Routing/Router.php:800 36 – vendor/laravel/framework/src/Illuminate/Routing/Router.php:764 37 – vendor/laravel/framework/src/Illuminate/Routing/Router.php:753 38 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200 39 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 40 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 41 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31 42 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 43 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 44 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:51 45 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 46 – vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php:27 47 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 48 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:109 49 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 50 – vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php:48 51 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 52 – vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:58 53 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 54 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php:22 55 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 56 – vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:26 57 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 58 – vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137 59 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175 60 – vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144 61 – vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220 62 – /home/u994695665/domains/emitra.co.in/public_html/index.php:20

1. Request

POST /sso/10/categories/store

1. Headers

• accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/*;q=0.8,application/signed-exchange;v=b3;q=0.7
• accept-encoding: br
• accept-language: en-US,en;q=0.9,hi;q=0.8
• content-type: multipart/form-data; boundary=--WebKitFormBoundaryGjBfho3AYXocBBTF
• content-length: 906
• cookie: page-popup-1-last-view-date=eyJpdiI6InZzUG5TOWY0c01aRUdRRm8rMGU4SXc9PSIsInZhbHVlIjoiYVhEdFZRRHVid0RJN3F3UkxyWUxQbHhFQzU4TjNXZE1wSjdhQlpaQnY2eTQzSmRjVjJtaFU4b3NiYyt4TXpBWDZCMnlRWVF1ZnVEQWI4dXE0dVI1WkE9PSIsIm1hYyI6ImUyODNiOGYwYWVhZDlmOTQ3NzJhNDFlMmQyOTE5Mzg0NTc4MWY2ZGVjYmJhNjA3MzRjMzIwYTZjZWRhYzRhMTAiLCJ0YWciOiIifQ%3D%3D; _ga=GA1.3.1625542975.1765090187; _gid=GA1.3.627553549.1765090187; user_documents_page_order=eyJpdiI6InltbERmOG5jRVhNNXRWYUFsUEJoRVE9PSIsInZhbHVlIjoiTFE5SGJaK3diK2NkeGJNZlBWUEIvMVRzUzMyZGxwN2RPVlhDYTEwY0VQdnJCdXZ0Z1M2ODBjRkNnTGI2UnZQQyIsIm1hYyI6IjU4ZWQ3YzIwNDA3Mzk1ZTQ0NWJhNWY0ZDRiYzQwN2Y3ZjA3MWU5OWNjY2EzYmQxODM2ZDUyZTI5YzViMDU4YTIiLCJ0YWciOiIifQ%3D%3D; XSRF-TOKEN=eyJpdiI6ImcxT0JnYjJPOFRJUTJwRDl3empnVHc9PSIsInZhbHVlIjoiQWlXYk9GbUtiMzRmNnRTYVQ1VU5VRW9sbW80Rk5aeWFJTkRNek5KQmZ0a0VYZnBaY0NxZnNoQzR5aWpXRmQrNS9jbGY1czBCbFJlbDhmQ1JxOXJiZGRZZnV1b0pBbEJQWXRDTUw1dXZ1L3VnbFhIM3hNb25NTnhoelN3cXBkdTYiLCJtYWMiOiJlNTY4Mjk3NmM2OGVmNWRkYWE4YmQ3ZjE5ZTg3NDJlMThmOWNhZjQ5NjAwYzAzOWIwMzRiNWQ3ZThlNjA2MGI0IiwidGFnIjoiIn0%3D; emitracoin_session=eyJpdiI6IlNHb2F5L2F0QlhMdDVkTnRCc2dlZXc9PSIsInZhbHVlIjoiYm5CUCt2NGJPY3ZYSkFLM0RUdG41c21aSE9jSCt0dUxoLy9lU1F0UUFlUkVTUUNGNmxWNEZnNWVTME9YWHBmaDQyMHZCSjhheFAzUllOSjZTTGtobEVwQzA5Q01NNHZldEVYS3JNMVhhM2NYZ1RZOG1kUkhJTkNJZitEUXRYakQiLCJtYWMiOiI5ZjA4YWQ1MmI0MWQ1ZTQ3ODRkYmJjYTU1OTc5ZDgxODZiN2JkYTMzNDZjNGIxNWNhZTIwZTE5MTFhOWZlMDhkIiwidGFnIjoiIn0%3D
• host: emitra.co.in
• referer: https://emitra.co.in/sso/10/categories/create
• user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36
• cache-control: max-age=0
• x-forwarded-for: 2409:40d4:111f:b4c7:595f:9568:4dba:d85c
• x-forwarded-proto: https
• x-real-ip: 2409:40d4:111f:b4c7:595f:9568:4dba:d85c
• x-real-port: 9357
• x-forwarded-port: 443
• x-port: 443
• x-lscache: 1
• sec-ch-ua: “Chromium”;v=”142”, “Google Chrome”;v=”142”, “Not_A Brand”;v=”99”
• sec-ch-ua-mobile: ?0
• sec-ch-ua-platform: “Windows”
• origin: https://emitra.co.in
• upgrade-insecure-requests: 1
• sec-fetch-site: same-origin
• sec-fetch-mode: navigate
• sec-fetch-user: ?1
• sec-fetch-dest: document
• priority: u=0, i

1. Route Context

controller: App\Http\Controllers\Dashboard\CategoriesController@store route name: categoriesStore middleware: web, auth, LanguageSwitcher

1. Route Parameters

{ “webmasterId”: “10” }

1. Database Queries

• mysql – select * from `smartend_users` where `id` = 1 limit 1 (1.05 ms)
• mysql – select * from `smartend_webmaster_sections` where `smartend_webmaster_sections`.`id` = ‘10’ limit 1 (0.37 ms)
• mysql – select max(`row_no`) as aggregate from `smartend_sections` where `webmaster_id` = ‘10’ and `father_id` = ‘0’ (0.32 ms)
• mysql – select count() as aggregate from `smartend_sections` where `id` != 0 and (`seo_url_slug_en` = ‘aaaa’ or `seo_url_slug_hi` = ‘aaaa’) (0.32 ms)
• mysql – select count(*) as aggregate from `smartend_sections` where `id` != 0 and (`seo_url_slug_en` = ‘aaaa’ or `seo_url_slug_hi` = ‘aaaa’) (0.24 ms)

Hello,
Based on the error details, it appears that you upgraded your website from an older version. The new version requires two additional fields that are missing from your database, depending on the languages you are using.
To fix this, please add these two fields by running the following code in your database through phpMyAdmin.

ALTER TABLE `smartend_sections` ADD `details_en` TEXT NULL AFTER `updated_at`, ADD `details_hi` TEXT NULL AFTER `details_en`;

Regards

Thx Sir.. GooD Wrk.. God Bless U..

Hello,
Thank you for reaching out.

Short answer: Yes, Smartend CMS meets all of your requirements.

Detailed answer:
1. You will receive the project exactly as seen in the demo, with the same frontend and features. Images in the demo will be replaced with temporary placeholders, but the structure and functionality remain identical.

2. You can create users with restricted permissions for content creation. These users can either publish content automatically or submit it for review. Notifications can be enabled for every new submission.

3. No code changes are required to improve SEO. The system is fully optimized, and you only need to add content with a proper structure.

4. All data from website contacts or newsletter subscriptions is stored in the database and visible in the Contacts module on the dashboard.
You can also integrate with Mailchimp or Mailcoach if you want to manage newsletters externally.

5. New modules, such as a Careers section for job listings or any other custom idea, can be easily added.

Best regards,

Note:
Turkish translation files are also available. If you need them, please contact our support team at support@smartend.app.
These files are not included in the project by default.

Hello, and welcome.

If you want to add a simple new module in Smartend CMS with standard fields, you can create it directly from the System Modules section and add your custom fields there. You can follow the same guide in the link below, but make sure to set the module type to “Private Data”:
https://smartend.app/docs/modules-forms-management/creating-and-managing-custom-forms

If you prefer to build your new module manually, you can structure it just as you would in any Laravel application by adding your own Models, Controllers, and Views.
In this case, you have full flexibility. Below are the recommended paths for your custom work:
- Routes: /core/routes/custom.php
- Views: /core/resources/views/frontEnd/custom
- Controller: /Controllers/Custom/CustomController.php
You can also add additional controllers inside the same directory: /Controllers/Custom/
Models can be placed in the default Laravel model directory or any custom path you prefer.

Note: After adding new routes, be sure to clear and rebuild your cache so the new routes and configuration are properly loaded.
Regards

and which better for SEO : local language url or english like url?

Hello, you are welcome.
The underscore is used only when the “Slug Translation” option in the SEO settings is set to “Always Use English Characters.”

If you want the system to use dashes (“-”) instead—which is recommended—you will need to download, extract, and overwrite the following file:
http://smartend.app/updates/12.0.0/Helper.php.zip
Place the extracted file in this path:

/core/app/Helpers/Helper.php

Note: You will need to run “Repair URLs” again from SEO settings to update the URLs.
Best Regards

I purchased SmartEnd CMS from CodeCanyon, but the ZIP file I download does not contain the smartend/ directory or any Laravel CMS files. I only receive the HTML frontend demo files.

Could you please provide me with the correct CMS ZIP package, or enable the proper download on my account? https://prnt.sc/0r5ygwTCPnBM

I downloaded the item multiple times from CodeCanyon, but the ZIP file I receive does NOT contain the SmartEnd CMS (Laravel) files.

Inside the ZIP, there is:

NO app/

NO vendor/

NO routes/

NO database/

NO bootstrap/

NO artisan

core/public is empty

Only HTML frontend demo files are included.

This means the ZIP provided to my account is incorrect.

Please provide the correct SmartEnd CMS (Laravel) full installable package, or enable the correct file in my downloads.

Hello sir,
It seems you are experiencing an individual issue. Please contact us via email at support@smartend.app
and include your website information. We will upload and install the project for you.

Hello,
If you want to move the website to another domain or hosting, follow these steps:

1. Move all website files to the new domain.
2. Create the website’s MySQL database and import the existing database backup.
3. Open the /core/.env file and update the APP_URL and database connection details. If you are working on the latest version of Smartend 12, You will need also to change the LOCAL_UPLOADS_PATH to the new one.
4. Finally Clear the website cache by deleting the following files:

/core/bootstrap/cache/config.php
/core/bootstrap/cache/routes-v7.php

After completing these steps, the website should work normally on the new domain.
If you have any questions, please contact us at support@smartend.app.
Regards,

Hello, you are welcome.
Please don’t share any information here in comments. You can contact support directly via email: support@smartend.app
With your website information to help you with any issue you are facing.

quck update : I have resolved the issue it was NGINX error.

Hello,
happy to know you have resolved the issue. If you have any questions please let me know. You can also contact support directly via email:
support@smartend.app

Hello,
The “Forgot Password” button appears only when the SMTP mail settings are properly configured, as the system needs to send you a reset email.
Please contact support via email at support@smartend.app To help you resetting the password directly through the database.

Hello,
To connect successfully to the license server, make sure both cURL and allow_url_fopen are enabled on your server.
If you don’t have permission to enable these settings, please contact your hosting provider and ask them to enable allow_url_fopen for you.

If the issue persists, please reach out to us directly via email at support@smartend.app, including your website and hosting details so we can assist or activate it manually if needed.

Hello,
This cannot be done directly — it requires custom development to modify the route structure.
If you’d like to inquire about customization, please contact support at support@smartend.app.

I’ll review it and get back to you as soon as possible.

Sir, I am waiting.. Cheers

Hello,
I’ve reviewed the slug you mentioned in action. In the new Smartend 12 update, the system automatically converts slugs to the new UTF character format when you update a topic’s SEO settings (I hadn’t clarified this earlier).
If you prefer to keep the old behavior where slugs remain unchanged, you can modify the helper file as follows:

/core/app/Helpers/Helper.php

Then replace the StringToSlug method with this one.

    static function StringToSlug($string = "")
    {
        if ($string != "") {
            $separator = "-";
            $string = @strtolower($string);
            $string = @str_replace(["/","&","?"], [$separator,"-",""], $string);
            $string = @trim($string);
            $re = "/(\\s|\\" . $separator . ")+/mu";
            return preg_replace($re, $separator, $string);
        }
        return "";
    }

Regards

Thank you for your great review.

Please contact the support team via email: support@smartend.app.
Make sure to include clear details about your issue along with your website information, so we can review and assist you effectively.

Hello,
You’re welcome.

You must add the new language you need from the dashboard — this means you should create the language first inside the system so that Smartend CMS can automatically generate all the necessary language fields and files for it. Without doing this, the system won’t recognize or display the new language properly.

To do this, follow these steps:

1. Go to Dashboard → System Settings → Local Settings.
2. Click Add New Language https://prnt.sc/JbwZzEb0FQjy
3. Enter the language name, short code, select the flag, and click Add https://prnt.sc/xt1DkL7yUeTt

This process will automatically create all the necessary language fields and files.
After that, you can edit and update the translations for the new language directly from the dashboard or from files as you preferred.

Hello,
You can find a detailed guide on how to create and manage public forms here:
https://smartend.app/docs/modules-forms-management/creating-and-managing-custom-forms
All form submissions will be received directly in the dashboard, and you can also enable email notifications for new submissions.
However, please note that there is currently no tracking feature available for form submissions or related services.

any suggestions to change it manually

To add it manually, Edit this view file

/Ucore/resources/views/dashboard/layouts/menu.blade.php

After line (276) And this code

if ($GeneralWebmasterSection->id == 13) {
  $LiIcon = '<i class="fas fa-tachometer-alt" />';
}

like: https://prnt.sc/ckOyTEJZ2vQ_
Change the number (13) to the module ID you want.

You can get the icon code from here
https://fontawesome.com/v5/search?ic=free&o=r
Regards

thansk a lot for your help

Hello,
There’s currently no video guide available for the manual update. Please follow the steps provided, and if you encounter any issues, contact support with your website details for assistance at support@smartend.app.

Steps to Upgrade Your Website to Smartend CMS v12.0.0:

1. Backup your website files – compress and save them in a secure location.

2. Backup your database – export a full copy using phpMyAdmin.

3. Save your environment file – download a copy of /core/.env. You will need its database connection details later.

4. Update your database – import the following SQL update into your database via phpMyAdmin:
https://smartend.app/updates/update12.0.0.sql.zip

5. Clean the root directory – delete all old files except the uploads folder (do not remove it).

6. Upload the new version – copy a fresh set of project files to your server, but do not overwrite your existing uploads folder.

7. Restore database connection settings – copy the DB credentials from your old /core/.env file into the new /core/.env file.
All info that starting with DB_, You can also set the APP_URL to your website domain and copy MAIL_ details if it applicable.

8. Rename the installation marker file – change /core/storage/_installed to installed.

✅ After completing these steps, your website should run smoothly with the new Smartend CMS v12.0.0.
Regards

Thank you sir, I have updated it as per your instructions. Your step-by-step explanation is excellent. ❤️

Hello,
This update must be installed manually and replace all files except the “uploads” directory , as it includes major changes to the structure and configuration files, and requires additional time to extract and replace all files and packages.
You can find the manual update guide here.
https://smartend.app/update-guide#manual-upgrade-guide
If you need any help, you can contact support directly via email
support@smartend.app

You’re welcome. We’re preparing to publish it within the next two days.
You can review the full changelog here:
https://smartend.app/release-notes

Thanks a lot for your efforts and great support.