About the Server Side Components category
Discussions and bug reports about the server side components included in Wappler.
Help with data insert
I am trying to insert data into three tables from one form, two of which are working fine, the 3rd, however I can not get the data to format correctly, even after scouring these forums and trying ever…
Why does the Wappler use whereLike but not whereILike?
Because under the hood Wappler uses the knexjs query builder for database queries, it’s not entirely clear to me why Wappler uses whereLike method, but does not use whereILike method, which is more un…
How to : Pass an Array to a Server Action to Write to the Database
Step 1 : Create server side custom formatter <?php namespace lib\core; function formatter_decode($val){ return json_decode($val,true); } Step 2 : Create client side custom formatter dmx.Forma…
Use npm at server level
Hi, I am playing with logging api calls using something called treblle.com (the client has seen this and wants it as it “looks cool”) It sits at the server level rather than page or server connect …
Bug or technical issue? Sudden error in my database/tables
Hi Wapplers all the way from Sydney Australia, Im having a problem which is driving me nuts. As I opened my project I received the followin error when I clicked on one of my database tables to view …
Some basic newbie questions on server connect / api development
So, after a couple of days playing around with Wappler, I might jump on the train and start a real world project. So be prepared for a number of questions on the server- and frontend side. Let’s star…
Image Upload Not Providing Path or URL... Under Certain Circumstances!
I’ve been following the latest tutorial videos from the wonderful @Hyperbytes that deal with image uploads and processing. Using a Wappler Local Server/NodeJS setup, I found that although the image u…
Api action not found
Hello, I’m new here, but quickly fell in love with Wappler and I’m definitely planning to stay for a bit longer, given the complexity wappler provides! However, I came across the database action issue…
Debug Server Action Values in NodeJS
Hi I’m quite new to wappler and nodeJS and I’m note sure how to debug or test my application. I know there are already a lot of topics around this (eg Best way of debugging code/queries) and I know h…
Security Provider for custom authentication service
I apologize if this question has been answered. I was unable to find anything by searching. I’m new to Wappler. I have an existing in-house authentication service (user/pswd, permissions) that I’d …
PDF integration using Docmosis
Hi fellow Wapplers… New to the community and I have come from Bubble. Still learning my way around Wappler but making slow progress thanks to Brian English and his fantastic video collection. I have…
Library APIs ignore the Global setting of a variable
It looks like the string.replace() function, if used inside a Library API, does not respect the Global name of a variable. This problem may happen with other functions, but I only tested with “strin…
Write file failed. Cannot read properties of undefined (reading 'generateConnectActionFile')
Hi, I am currently following the Wappler 5.0 Quickstart playlist on YouTube and I am already at the part to create authorisation code to send to receipient upon registration. So I have setup the smtp …
MySQL port 3307 error
Ben, you are changing only the database connection in database manager for Wappler itself, but you need to change also the database connection in the Server Connect panel, globals, which is used for y…
Params in Custom Query
Hi, When I try to use Parameters into custom query it does not work. This not working: CREATE TABLE :P1 Even changing with “?” not working: CREATE TABLE ? After debug i get: message: “SQLSTAT…
Wappler Roadmap comments brought this up . .
I see this as a Wappler Extension from Ken in Feb. 2022 – Have you ever had use for JavaScript functions that run once or a specific number of times? Did these functions need to be retried if …
Load image componant not working
Hi all, I am running Node.js and the “load image” component is not working in my workflows. I keep getting the below error. I think I am missing a module. Can someone help me out on this? { “status…
Parameterising the email client Mailer
Hi, Is there a way of parameterising the Send Mail Mailer ? I’d like to parameterise the send mail component to send from each client’s own SMTP server (e.g outlook, ecxhange, 365, Gmail) in a multi…
Nested repeats not showing in $_POST variables
Wappler Version: 5.1.1 Operating System: Windows 10 Expected behaviour Posted value shown as nested Actual behaviour Posted value not nested How to reproduce Create a form with nested repeats …
Wappler for lean, server-side-driven, SEO-focused Website?
Hi I’m planing on build a new project: a data driven product comparison website. It’s going to be a rather “normal” DB-based websites with some interactive components (like filters, voting, forms et…
Included library action output not available in API workflow
Wappler Version: 5.1.0 Operating System: MacOS Ventura Expected behavior Adding a JWT sign action as a library workflow and including it in an API workflow should list the JWT sign output as an opti…
Output fields no longer showing on server side repeat (php model)
Wappler Version: 5.1 Operating System: Windows 11 When creating a repeat step in the apis, it should offer, or reflect out put fields. Example from an existing api action: GUI:
Can't use 'greater than' or 'less than' operators with big int fields in the Database Query Manager
In PostgreSQL bigIncrements results in BigSerial field which eventually is threatened as string and not as number as it is a king of uuid. So that is why you have the strings operations available onl…
Custom Query - Undefined binding(s) detected for keys
Hi, I’m trying to write a custom query to “Insert into” a SQL table. However, I’m having trouble getting the parameters to work properly. As I try to bind the post parameters to the SQL query, it’s g…
Database Insert is Inserting but Throwing an Error
Could you try setting Enable 32-bit applications to true in the server app pool where your app is running. Upgrade to 4.0 - “Arithmetic operation resulted in an overflow Error” - MySQL driver issue (…
SMTP Local > Error 500
Hi, I’m following the great tutorials from @ben on youtube and everything working fine except that confirmation email is not working. I tried with sendgrid, mailgun and gmail. Same error : 500. In …
Node.js Server Action not Working
Wappler 5.0 Windows 11 Node.js/MySQL I’m starting a new Node.js project and this is my first one so I’m not 100% sure on what I’m doing. LOL. I have the site running with a basic template page and…
Text search of Nested Query data
Hey! Am just running through some queries using the new nested table functions. Generally these are really good and easy to use. I’m struggling to find a way to deliver a text search of the nested i…
Reviews? Digital Ocean?
Now that I see Linodes.com (I run 3 web apps there) management has been added to Wappler I’m asking today from Digital Ocean users some feedback: Loves? Convenience? DB connections dependable? 22.…
Routing on IIS Windows Server Not Working
I’ve read everything here about routing issues on IIS and spent about ten hours on this so far - I’m banging my head now (I’m sure you all know the feeling har har). My issue is relatively straightfor…
Is it possible to use the sub-tables for MariaDB?
When I follow this tutorial Using SQLite I finish up with Using MariaDB the result is Querying the SQLite version Doing the same for MariaDB In other words, is it possible to use the …
Docker & Portainer Install on Virtual Hosting Info?
I have now 3 virtual hosting containers at Linodes. I was investigating using Portainer to manage it all. Then I saw the Portainer reference on the Beta 8 update. I’ve installed Docker on a new vir…
Switching between V4 and V5 Extension Update Project Assets Update - Learning
I wanted to test the slideshow component not working v5B6 so I went back to V4.91. When I open 4.91 I greeted with Project Asset Update dialogue and an Extension update in the title bar. I have be…
Remote DB on Digital Ocean
Ok I have reached a level of frustration that I need to reach out. Firstly, love wappler, it’s outstanding and if I can get my little frustratiion figured it will transform what I do! I’ve spend way…
Performance question server api
Hi! With every single server api call, I include the same library action to get the user’s company ID, role & permissions. So when a page loads all server api’s, it does that same include for every s…
Server-Side Regex Broken?
Wappler Version: 4.9.1 Operating System: windows 10 Expected behavior What do you think should happen? The pattern should be found according to the regex validation on the server end. Actual beh…
How to generate unique random string with ServerConnect
Hi all, I have a table “pages”, containing columns “id” and “slug”. User can create a new Page and I need to automatically create a unique “slug” for it. Here is an example: pages.cc/X1Af9M “Slug…
S3 Connector
Hello, I am trying to use the S3 Connector but encountering some issues. I was hoping someone could help illuminate what certain fields are for. For context, I am using Auth0 to have users log into m…
Edit query
I might be missing something but I try to edit a query, previously created the UI does nothing. I mean I hit the ‘query options’ button and nothing happens. (it is a paged query, with alliases created…
Criteria for Identity?
Hi, I’m not getting an identity returned after inserting a record. My ID field is a uuid (created from a custom formatter). It’s database field is user_id (in this instance). After insert I have a…
How to set a dynamic property name in a JSON object
Hi @patrick, I am trying to set a dynamic property name in a JSON object but the {{}} substitution does not happen. This is an example of the JSON object: { “$set”: { “index_history.0.execution_ti…
Include files vs old information
Hi there, I´m a graphical designer that worked with DW. Now I´m trying “Wappler” and like software but I feel lost with all the information that is available but is outdated. I believe no one uses ol…
Security Provider Login Problem PHP
I make a > login.php page. If it finds the Username & Password values in the table “userlogindetails” it rdirects to the formpage.php. Groovy. Done this successfully often but not within months & …
API medium Blog posts
Dear Wappler team, I am trying to call Medium service to post from wappler a blog entry. the Documentation from Medium for their API is : Creates a post on the authenticated user’s profile. POST htt…
Failing to Pass Posted key id value inside SPA
I have a multi-step form to insert a new record. After the user submits the form and it is saved to the database table the next step that appears is to show a read-only table confirming that the subm…
Connecting to MSSQL DB ok ... no queries possible
In Workflows / Server Actions under Globals / Database Connections, there you can set the PHP specific connection.
500 Server Error after setting up Wappler on another Mac [SOLVED]
I’m brand new to Wappler (coming over from Bubble) and am going through Ken’s getting started tutorials. I was initially working through the tutorials on my main Mac Mini M1 and just set up Wappler o…
Identity available, but not to Update DB
Hello! The identity from my Database Insert is being passed along in my Server Action Workflows. I can see it in a variable, I can use to query the database, etc. But, whenever I update the datab…
Problem submitting 2 forms on spa page
I’ve created a SPA which must have 2 forms – One for login username & password fields and the next one in the page order for a separate form processed by a different API for inserting the form fields …
Need better Conditional for php include file
PHP project, Apache server, mysql database My index page is the login page. Username & password. LoginCheck API – compare posted username & password to table.users records – find matching record or…
Most up-to-date Doc or Tutorial -- conditional php server side include
Rather than spend another 20 minutes more trying to find the best solution – (Searching gives me 99% questions and/or years 2018 to 2019 topics) I know Forum readers can point straight to what I need…
CSV Import field to Array - Is it possible?
Hi guys, I would like to import CSV field as Array. Actually it is array because value is [{"#text":"Odstíny hnědé a béžové","@_xml:lang":"cze"},{"#text":"Shades of brown and beige","@_xml:lang":"eng…
Full Server Side Rendering in nodeJS
Hi I’m not sure if I’m looking for the wrong thing or just too unexperienced in nodeJS to understand it, but I can’t wrap my head around how to build website in nodeJS that is fully rendered serversi…
[SOLVED] Can Scheduler use existing Server Action API?
Maybe this needs to be a request for enhancement, but I would like to reference an existing API in a schedule. Is this possible?
Remote target local database connection without docker for nodejs project
I have nodejs project with xampp serving local database (mysql/mariaddb) for local development target. And a custom remote host (VPS) setup with nodejs /nginx /mariadb -phpmyadmin access as a remote t…
Linking or daisy chain different tables onto one page
Hi all, Still learning here and just wondered if you could point me in the right direction. This is a backend query in relation to Database in MySQL. So, I have the following tables all in the sam…
Security Login interface does nothing
Hey @inbdigital I actually helped a user with this a few weeks ago: This may help you a little
Append Server Connect for "load more" or "infinite scroll"
Hi I build a item-list with a server connect and infinite scroll as shown here: https://www.youtube.com/watch?v=RbZWWlgcVaY It’s working fine so far. But if I scroll down quite far, the response get…
Simple Web Scraper in Wappler
Hi for my project (nodeJS) I need to scrape some Data from an other website. I have done similar things in the past with php and python, but I don’t know how to approach this with wappler. I have no…
Has anyone used the YouTube API nextPageToken before in paginating?
Has anyone use the YouTube API nextPageToken before. Current YouTube limit is 50 record in a GET, if you want more you have to use the nextPageToken. Let know if anyone has a use case I would love to …
How to login with an Email field or Username field using Security Identify
If my registration form let users sign up by entering (email, username, and password) I want to allow a user to be able to login using that email field or username field when they want to login. Has …
Error message from API call
Has anyone ever got an error message like this when making making an api call? @Teodor or anyone. Thanks in advance.
How to filter email in query?
I want to condition a query to return only valid email. Am I doing it correctly? How will this effect performance? Reference
Database insert’s identity returning “INSERT”
Wappler Version: 4.2.0 Operating System: macOS Catalina (10.15.7) Expected behavior What do you think should happen? I would expect to be able to use the identity value which gets returned from an…
Connect to DynamoDB
Hi I am working with a DynamoDB AWS Service and I’d like to know if it is possible to connect to this using the direct database connection. I am seeing only directions for connecting to Amazon RDS in…
Concurrent Executions of The Same Server Action
I have a server action which calls an external service to send and email and writes multiple records to the database. Overall it takes around 3 seconds to run. I would like a user to be able send an …
Security Provider Enforcer
The Security Provider Enforcer don’t work. I tested and when i login to the Security site its ok and when i go to the same site, the site go to the non permission site.
How do I transform JSON?
By API, I receive a file in JSON format. How do I convert the file to key:value format? This is the result I want to get. Please help me solve the problem.
Security login
Hi, Using NodeJS as the server model, added database connection and it works. Like the tutorial stated i’ve created a “security provider” and thats all ok. Next step in the tutorial ( https://docs.…
MYSQL_ATTR_INIT_COMMAND - pls help
Hi guys, i moved an app on a new server and i get an error, i don’t know what to do anymore, pls help. Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’ is the message The app runs on the dev envir…
Proposed solution: Data transformations return { } instead of null
*I’m still using Wappler v 3.9.6 **I know that altering core files is not a good practice, but I intend to share this as a possible fix for official implementation. When using server-side Data trans…
Direct Database "Remote Connection" Target vs Local Docker Database Connection
Hi Wappler Folks Wondered if you can point me in the right direction if this has already been discussed in the Forums, our if not already in the Forums, perhaps give me some guiding light?? I have a…
Security/Login to existing Database
Hey, I am trying to authenticate an exisiting user-table in a MySQL DB: I have to compute a Hash based on UserID, Password and a “ServerID” from another table. So far so good, I generate the correct …
3.6.0 Real Time Data Updates - With PHP?
Wow… am I dreaming… Does this work with PHP?
404 route not found error
Wappler version 4.0.1 Nodejs server model Docker MySQL database Hosting on AWS When trying to publish a registration page, I get the following error: The code for the page is as follows: T…
Websocket Error
Hi there! I followed “Realtime Data Update with NodeJS and WebSockets” for live data refresh. Now, it works perfectly inside Wappler, it shows the data update in realtime when I add a record from ano…
Why can't I use the result of a query in a following step?
I have the scenario where I have the details of the organisation in a database table. I want to use the values to populate the sender fields of an email as illustrated. However, the values don’t se…
How to encodeurl email addresses that have a + in them
Hi there fellow Wapplers, I have a small issue in setting up the password reset link flow, as beautifully explained by @mebeingken in his cool 2nd Wappler course. For testing purposes I often use gm…
Issues with PostgreSQL Array Data Types in Workflows
PostgreSQL allows to setup ARRAY data types for almost all data types: int, text, varchar, etc. UPDATE Step in Wappler should be able to do this: update my_tbl set my_field=ARRAY[1,2,3] where id=1; …
One table : filter and search
Hi, I got a problem and don’t find the information in the documentation (not to mention that 90% of the documentation is outdated and screens are far from what they look like today, really make the l…
Server Connect Response - forcing blank body
I’ve created a callback (to pdfMonkey when creating a PDF) and it’s failing consistenly as the callback oonly wants a 200 OK with a blank body. Leaving the repsonse->text blank but Wappler’s decided …
Asp.net: error with database query
I have a simple query with result. When i try to create a dynamic first I make a server connection: I have an error 500min debug!. Why?
Serveraction failed network xhr preview empty
Hello everybody, thank you in advance for your time. I’ve a php project with mysql database in a cheap hosting. Connection test with db ok, I can even insert table from wappler. When I try to do a…
API query params optional?
Is there any way to make the API’s query parameters be active only under certain conditions? This is an action that lists sale offers and there are various parameters I can use to filter the list……
BS4 forms Docker node.js mysql not inserting
Adding BS4 register form, with no security or validation added, to keep it simple. Fails to insert record on local server but works on digitalOcean remote server… Can anyone help??
API action disappearing fields
Wappler Version: 3.9.7 (but was already present in the previous version) Operating System: win10 In API Action the query and headers input fields become invisible when JSON input data is long. T…
OAuth2 authorization problem
I’m having issues with OAuth2 access token in Wappler. I’m trying to connect to allegro.pl (which is an Ebay type site). I have followed their documentation but getting no luck to get it to work in W…
File missing from local target web server
I have made a simple contact page that I am inserting into a database. I am doing everything on a local target but have run into an error. After creating a new page, new server action the same way I h…
OAuth2 help getting token
Hello, I’m trying to figure out how to use OAuth2 in Wappler and I’m having some issues… I followed Using OAuth2 Connector with Facebook and had no problems there but now that I’m trying to connect …
Join data transformation doesn't work with single query
It maybe is not documented that good, but all the data transformations only work on collections/arrays. A workaround would be to just not use single query but use the mutliple records and limit that t…
Deployment on remote server problem
locally my site works perfectly. the deployment on a remote server the contents related to the MySQL and php database are not displayed. can someone help me? thank you.
Rename Columns displays the old name in the dynamic data picker
OS info Operating System : Windows 10.0.19042 Wappler Version : 3.9.3 Problem description In the dynamic data picker, Rename Columns displays the old name and not renamed name. Steps to reproduc…
How to set values of an Object's variables?
Hi, I have created an object with a Set Value action and defined its variables via Define Schema. How do I now set the values of the object’s variables? Thanks Allan
Custom database query always the same error
Hi, When I try to build a custom database query and try to execute it, I always get an “request failed”. And in the logs I find: — 550 dmxConnect/api/__exec_query.php: No such file or directory I’m…
Can the contents of $_POST be used directly by S3 Connector to save to a cloud storage?
Hi, I am writing an inbound API and I want to save the contents of $_POST via S3 Connector to DigitalOcean Spaces. Do I need to save the $_POST to a server side file first and then send that file via…
How to Create API-key Enabled Server Actions?
I’m looking for ideas on how to create a server action to support API keys. My initial thoughts are: create a role of ‘API’ create a user account for the api (username=api_key_value, password=api_s…
Cannot see Oauth2 data bindings
I am looking for help in using the Oauth2 module properly and have two related questions. When setting up and oauth process for Xero initially I pasted the Client Id and Client Secret directly into …
How to get uploaded image name using Exec Library item
Please ignore my plea for a solution. I have found the solution by adding a Set Value to the Library item.
PHP Server Action Replacing \n with \\n
Wappler Version: 7.8.2 Server Type: PHP Expected behavior What do you think should happen? In a .replace(), Wappler needs to retain the value of \n within the PHP it creates. Actual behavior Wh…
CSV import of date field with null
Is it possible to import a CSV file containing a date field which can have null values into a MySQL database? Using an empty field, ‘null’ or ‘\N’ all generate the error "Error: ER_TRUNCATED_WRONG_VA…
CSV Export system path error
I am trying to export the results of a query as a CSV file in a server action but the path generated in the action properties is causing an error. The path was selected as below This shows in the …
Amended query remains the same
Wappler Version: 3.7.6 Operating System: Big Sur 11.2.1 Expected behavior Having changed the database structure I amended a simple database query. Actual behavior The GUI showed the change had …
Disabling Library Include Doesn't Work
If you disable a Library Include step, then the actions within it shouldn’t execute Actual behavior They do execute! How to reproduce Create a server action with a library include step which you ca…
Is this a bug? Api action json data, i cant format correctly the values of an array
Hi, I am working with an api which requires that I send with the POST method an array with 2 number fields: “unit_price” and “quantity”. I get these values from this query: So this is my code in…
Database connections mess
Am I the only one having problems with managing database connections after they got moved to the “Globals” section? I am pretty sure I did not create that folder… I have multiple targets and while …
Adding/updating fields
Hi, I’m trying to apply database changes, but I got this message. How can I make the proper changes to save everything? Fields I’m using: Here’s the code for it as well: exports.up = function(…
Database manager error
Hi. I work around a dynamic site with php server model and mysql db, when i try a db connection with database manager is impossible because return ETIMEDOUT error and no load db schema. If i make a c…
How to execute a CLI command?
Hi everyone! I am new to Wappler I want to execute a CLI command. In node.js, I can spawn a child process and run my CLI command. For example, var exec = require('child_process').exec; var cmd = '…
AAAAGGGGHHHH... Just Realised PHP Session Variables Get Shared Between Browser Tabs!
Having built my entire booking form’s server actions based on storing values retrieved from the database in PHP Session variables, I have just found that those variables are shared between browser tab…
Security Provider Help
Basically I have a user generated page that I only want the user who created it to be able to edit and anyone who isnt this user to be redirected, I assumed id something like the security identity but…
Condition criteria displays incorrectly
I have the following condition: (tid < 1 && fid < 1) || (tid > 0 && fid > 0) But it displays incorrectly: How to fix it?
Monitor node js post request to remote server
Hi. I’m a newbie on Wappler and learning it with the Docker/Nodejs set up after following Ken’s excellent tutorials. I’m replicating some Python code to make a POST request to a remote server. The pr…
Need urgent help
I have spent the last two days trying to fix what should be a simple problem. I am unable to to get a simple query or even a database insert to store from the database. Background I am not receivin…
Server Connect Validator not working with global db connection?
Wappler Version:3.6.0 Operating System: Windows 10 What do you think should happen? Validator should query DB and return error for duplicate records in the database. What actually happens? Ser…
MySQL json field
Hi! Just trying Wappler for the 1st time and loving it so far. However, there is one feature that I can’t seem to get working. I have a MySQL database with some json fields in it. I would like to be a…
It is impossible to save linked DB actions after upgrade to Wappler 3.6.0
Wappler Version: 3.6.0 Operating System: Windows 10 Pro Unfortunately, I cannot update existing DB-Actions. See please the video: bandicam 2020-12-12 12-09-37-727
How to delete summernote file before upload
Hello, I have been trying to implement the summernote form into a site. I checked the tutorial but I have an issue when users want to delete the image already inserted in the system. The goal is to …
Use mysql stored in paged query
The Database Paged Query is a great thing! Is there a way to use mysql stored functions in the Query options?
How to decode a base64 image to a file server side
I found information about client-side decoding but nothing that explains how to decode a base64 image to a file server-side?
Use $_ENV in the new Cache Time setting
I’m trying to use environment variable with the new redis cache feature on api action. I have a simple action that return a database query with multiple records and I want to cache this. When I put 1…
Server side data binding does not work for mailer
Wappler Version: 3.6.0 Operating System: Windows 10 Pro It is impossible to load mailer settings dynamically. Please see video: bandicam 2020-12-12 12-38-51-281
Summernote url image path store in db
Dear all, i am using summernote in a blog entry . I can successful upload the image upload via the sever action call. So currently i am using 2 server actions. One to create the new blog entry , an…
SSL Problems With S3 Delete File Function
======== TEMPLATE BUG FORM ======== Wappler Version: 3.5.5 Operating System: Windows 10 Expected behavior According to a support response I have from AWS, when attempting to delete an S3 file, the…
Session Storage Manager variable value in query?
Is it possible to create a query and set a condition where equal to a Session Storage Manager variable value?
Server side_security provider issue
Hi, I create a security provider and for some reason it’s not display any new tables that i insert in my DB. I try to refresh it, restart all services , nothing. It always list a wrong list of avail…
Validate data rules is not working, if database connection coms from globals
Wappler Version: 3.6.0 Operating System: Windows 10 Pro If I link the db-connection internally within an action, then it works. Please correct it!
Reusable actions are not linked correctly
Wappler Version: 3.6.0 Operating System: Windows 10 Pro I should then change it manually. See please a video: bandicam 2020-12-12 12-28-59-103
Appl flow issue
Dera all, I am trying to put a new step in a app flow a server action (to delete a record) . The issue is that i cannot select a server action. I am attaching the photo! -https://www.dropbox.com/t/VK…
S3 Upload Control `% complete` Display Goes Straight to 100%
======== TEMPLATE BUG FORM ======== Wappler Version: 3.5.5 Operating System: Windows 10 Expected behavior When I use the S3 Upload Control element to upload a file, the % complete display should r…
How Do You Say "If This Array Contain This Value"?
I have the following in a server action: $value - the id of an item e.g. 123 response - a comma separated list of ids, e.g. 120,123,125 I want to create a condition in a server action which says th…
How to Manage PHP Session Variables That Disappear When The User Is Inactive For a While
I set some PHP session variables when my user logs into my app. Generally they work very well. However if the user leaves their computer for a few hours, when they come back, the app is still runnin…
Emailer body text templates
Dear Wappler team, I am trying to embedded in the body text area of wappler mailer email some formatted html text. I also trying to embedded an image as the banner to the email. My results are the …
Gmail mailer authentication issue
Hi , I had try many different recommendations from the forum to solve the 500 error (mailer smtp authentication error), without success. I setup my gmail account for less secure apps, i disable two w…
Issues with Setup mailer
Good afternoon, I am running Wappler 3.5.5 and i have a serious issue setup the email. I am creating a new server connection step , i am selecting setup Mailer and then properties displaying the name…
Data base connection error - 414 Request-URI Too long
Hi, I am getting the following DB connection error (when I trye to save the connection). But there is no error when I just test it This connection worked perfectly before. Regards
Execution of Server Action After Browser Window Closes
I have a situation where the user clicks on a button which sets off a server action which takes around 5 seconds to complete as it goes out to an external service via an API. If the user closes the b…
Email 2 step authentication (2fa) implementation - looking for feedback
Hello, I am embarking on a quest to build a two step email authentication for my web app (there are good reasons not to use Google Authenticator). I’m nearly there but I’d like to humbly ask the com…
Calling a PHP Guru - What $_SERVER[] Variables Will Give The Root Of My App?
I want to assign a value in a server action that is the root of my app’s url address with the correct use of http or https… so for my production server it should return https://app.my-app-domain.com …
Classic ASP Mappath error update
Here are updates for everyone using Classic ASP and encountering Mappath errors after upgrading to Wappler 3.5.x Update for Database connections, unzip in dmxConnectLib/lib/db. connection.zip (1.5 K…
Global setting properties for Database Connection not visible for ASP.NET projects
Hi @nocodegems, I believe the issue will be fixed in the next update. From reading your post, it looks like it is the same as
MS Sql pagination error- incorrect syntax
Fixed in Wappler 3.5.1
PHP/LAMP on Server A, MySQL on Server B - Database connection always tries to connect to Server A
Hi, I am trying to setup a project on a server: in ProjectSettings/Targets, I set up Webserver / PHP via SFTP to Server A. Thats working so far. I chose this as target. When I try to set up a Dat…
Custom module " return key and value "
Hello @patrick, I created a function like this and I want to use ‘RandomNumber’ as key. However, I cannot get output as key and value, I just see the “value” as in the screenshot and I cannot use thi…
How Can I Pass an Array to a Server Action to Write to the Database?
I am creating a booking form. It can manage up to 6 attendees, and each attendee can be asked any number of questions. I want to find the most efficient way to write the question responses to the dat…
Unable to update based on identity
Hello, I am working on an email based two step authentication flow and I have a Server Connect process that goes like this: The idea is that you log in, SC generates a random string, stores it in …
Is This Server Action Condition Valid?
I have the following server action condition which looks valid enough to me, but it is giving a strange display in the Condition Properties box below. Is there something wrong with my condition code,…
How to Set Default Public Access On your AWS S3 Bucket
I’m creating a bucket for my users to download image files that will display on their pages of my app, so I wanted to create a bucket which has complete public read access. After some googling, I’ve w…
Cannot Access the "Saved" Security Provider Connection
Okay Wapplers, Can one of you seasoned experts tell me what I am doing wrong. We Cannot Access the “Saved” Security Provider Connection to Create a Logout Button. We are creating a Login System follow…
Single record query and update not working
I have tried to a single record query by hard coding the userid name in the Querybuilder, but it just displays the form with empty record. How can I debug this. I have turned on debugging, but not …
Stuck with an error importing CSV to Database!
I’m following this tutorial - Uploading Single File To Your Server to upload a CSV from the frontend as the first part and then reading that CSV to input the CSV rows into my DB. But I am hitting thi…
Redirect Action no working with NodeJS
Wappler Version: 3.2.2 Operating System: Windows 10 Expected behavior I’ve created a redirect in my action steps, so user should be redirected. Actual behavior The user is not redirected, instead, …
Database insert's identity called from repeat returning "INSERT"
Wappler Version: Latest Operating System: W10Pro latest Server Model: NodeJS Expected behaviour This SC script is supposed to insert a product record in the database and update that record’s images…
API rest calls and certificate errors
Our developers are working on “an api call from with a server action” with a third party. When attempting to connect to the third party, we are receiving Certificate verification errors, as the third…
Server API post, How do I create JSON input from a query (multiple records)
Hi everyone, Here’s my scenario. I am issuing an API request to an AWS service and want to submit a list of questions and answers. Here is a sample JSON body. { “key”: “testkey”, “faq”: [ { “q”:…
Condition Node + MySQL: Cannot read property 'get' of undefined
Working on the update for today, you may test the following file. Replace it in lib/core. app.zip (2.5 KB) It will also be included in todays update.
How Do I Prevent a Server Action Stopping When An External API Call Fails?
I have a Server Action which calls an external API to send an email. If there is a problem sending the email, the external API appears to sends back an error HTTP response which then makes my server …
How Do I Debug A Large Server Action?
So I have a long Server Action. LIke at least 200 separate action steps. Then I get an error message like this: code: 0 file: "C:\Users\anton\Dropbox\workshop-angel\dmxConnectLib\lib\db\Connection.p…
How Necessary is $parent Within a Server Action Repeat?
I have a server action structured like this: Database Query contact repeat something Set Value this_text = {{this_text.replace('[First Name]', contact.first_name)}} This is working completely oka…
Database Query to Find A Random Row
I am building a system which views shortcoded messages that can be sent to different contacts. I’m on the part that searches for a random contact to choose when seeing how your message will look befor…
API problems on the server side
Hi all, I had a working client side API call to return some data - worked perfectly, but I want to conceal the source so implemented the same call on the server side, it’s an exact replica (and I’ve …
Test a String Contains [A-Z], [a-z] or [0-9] in Server Action
Is there a straightforward way to test a string in a Server Action to check it only contains [A-Z], [a-z] or [0-9]?
Wondering what is the general rule for security in each server action (e.g. just security provider, or both SP + SR)?
Hey all, As the title suggests - i’m still building out the app - but will need to soon start to make sure I have everything secured as best as possible. In any action that the recruiter would requi…
Use of Security Restrict When Calling Server Action as an API
I am calling a server action call_me.php via a post call from a server action call_api.php. All works okay, but if I include a Server Restrict action in call_me.php then I get an authorisation error. …
Node.js and Server Actions: Facebook Auth Issue
Hi, I get this error: “Error: oauth.provider: client_id is required” when I try to log in using Facebook OAuth2 Provider. {“status”:“500”,“message”:“oauth.provider: client_id is required.”,“stack”:"…
Retrieving Dynamic Json from API
There’s an API I use that serves up data in JSON format. Unfortunately Wappler’s JSON Data Source appears only to let me select a static JSON File. Does anyone have any suggestions for me as a workar…
Extracting timestamp from brackets
I need to get the UNIX timestamp value wrapped in brackets like below returned from the Xero API and post it as a date. Is this possible with the split function (or any other wappler functions)? “Upd…
How should I correctly setup a multi-insert workflow (screenshot included)?
Hey all, Again, learning how to do things the Wappler way instead of the Bubble way. Right now, I’d like to create a two records each in a different table, that are linked to each other. In Bubble,…
Forms not connecting to database
I have a successful connection to my remote database (direct database connection) and can view/edit my tables. However I can’t seem to connect with the database through forms (e.g. simple insert form…
Custom update query parameters - strange behavior
I notice that whenever I use more than 1 param it either doesn’t work or just copies values from the 1st param… I was trying to get to the bottom of this so I set up a test page with a query and serv…
Copy a Table Row in Server Connect Action
Is there a simple way to copy a table row within a server connect action without needing to read it in and then explicitly allocate each column from the read row into the copy’s columns? I have a sto…
Email-will not be send
I have a .php site and followed all instructions below. My problem is as follows. Giving up no email goed ok (required message), giving up an unknown message will be checked against the database and I…
"SQLSTATE No such file or directory" Error When Server Actions are Invoked on Production Server
Wappler 3.0.0 rc2 I’ve uploaded my design to my AWS server in the way I normally do, but this time none of my server actions which access the database are working… I’m getting the following message: …
Get PHP session id
Hi, So for audit purposes i need to have the PHP session ID that is created during the Security Login stored in a DB, i could get this via the $_COOKIE[‘PHPSESSID’], but this one is not set on the i…
CSV Import doesn't trigger Success Event after 1 minute
I have a rather simple CSV import set up with a query that checks if the record exists and then some inserts. On the front-end there’s an on:success notification to see when the import finishes… It …
Node.js serveraction "Cannot read property 'get' of undefined"
My “post” server-actions in an existing project (tested it also with a new one, same problem here) are all failing with the following error message. All “get” server-actions are okay. Is this a wapp…
Updating Routes, SPA
Hi, very new to wappler, many years with dreamweaver. Gotta say i love it thus far. I’, working on a SPA. my dashboard has several routes on it, see the below image as an example. Each route has queri…
Delay Server Connect
I’m trying to understand the “correct” structure for a SPA. Here is what I have Template A contains 3 Server Connects SC0 that contains data for the common template SC1 that contains data for vi…
Server Connect to route
How do I add Server Connect to a Route?
Error: failure to load resources. Please help I attached the debug info
Hi, I have been getting an error all evening. Everything was working fine then all of a sudden the server seemed to lose access to the server action. When I tried creating a new one I received the s…
Insert to database create empty record
Hi I’m new to wappler and I’m very enthusiast. I created a server action to add a new user to the database. The status when the form is submitted is 200 OK but it create an empty record to the datab…
Displaying multiple values in a table field with multiple joins
Hi all, I am trying to create a table where a field value is displayed multiple times, with each value separated by a comma in the same record, instead of having multiple records. For example: I hav…
Saving multi select field to database
Hi everyone, Can someone help with providing a way to save a multi select field to the database. I have three tables - doctors, location, and a many-to-many to link them. A doctor can work at multi…
Array to String in Server Connect
So I’m looking to add a csv export button on a page. The server connect file for the page uses a repeat to get 2 sets of nested data. I’m struggling with getting the nested elements to collate as a c…
Filtering Nested server connect
Hi, I’m working through setting up multiple filters on some nested data. The data is a list of users, the nested elements are admin permissions and programme access. I can create either standard or c…
Is SSI currently working with nodejs projects?
I followed this steps : https://docs.wappler.io/t/server-side-includes-ssi/2864 except that the file i include is a html file. On Wappler design editor i see the included component. But when server i…
Help With Extracting a SUM from the database
I want to use the sum of some values from the database. I have this query called booking_allocations: Which I assumed would return the sum of the fields found. However it is only returning single …
Wondering When Server Action Bugs Will Be Fixed
There are mulitple bugs in Server Actions which I reported in this mammouth (unlisted) conversation a week ago, and I’m now finding other users are getting very confused about too, so I’d love an upda…
Assignment of Session Variable to a Set Value in a Server Action Is Incorrect
Wappler 3.0.0 b1 Step 1. Assign something to a session variable called session_test. Step 2. Create a Set Value called variable_test Step 3. Use the menu system to assign the value of session_test t…
Noob with an Index.php Issue
Hey Wapplers! First off let me say Wappler seems like an amazing piece of kit! I am dipping my toe in using the trial having come from PHPRad - I feel PHPRad was a bit too buggy and didn’t let me con…
Relating XHR Error Message (#1, #2, #3) etc to my Server Action
So I have a very big server action I am trying to debug. In the “trace” part of the XHR error message the very long message is divided into parts like #1, #2, etc. Is there a simple way to relate th…
Building dynamic nested json/object structure with visual expression builder
Is it possible to support building dynamic nested json data (objects) in the new-world visual expression builder? May be it’s easier to achieve with nodeJS if not supported for the current PHP model? …
API action component - JSON data not taking dynamic data
Wappler Version : 2.6.4 Operating System : Mac OSX Catalina 10.15.3 I think this might have broken from v2.5.6 (Wappler 2.5.6 Released). JSON data stopped taking dynamic data when using data pick…
Oracle Database connection
Hello, Is-there any possibility to use an Oracle database? regards,
Access headers in SC
I’m using a server action as an API endpoint and I need to be able to pick out meta-data from the header that is sent. Is this possible?
Set Value - Cannot Concatenate More Than One Value
Wappler 2.9.1 I want to use a Set Value statement to create a string which looks like this: Payment PAYMENT_NUMBER (DATE), PAID_BY_NAME by PAYMENT_METHOD - £AMOUNT But each word in capital letters …
401 Unauthorized - Is it Always To Do With Security Restrict?
Just to be clear… if I have a 401 Unauthorized, will this always be because I am failing to pass a Security Restrict statement in a Server Action?
Connecting to DigitalOcean Managed MySQL Database
I’m getting an error setting up my Target connection to a managed MySQL database on DigitalOcean. I’m getting the error below. I suspect it may have to do with password encryption, but I don’t know. …
New database tables not immediately available in server actions
Hello, I ran in to the issue that newly created database tables and fields are not available in the server actions properties immediately, but do appear after a while. I did apply the database change…
API schema editor issue
Wappler Version : 2.9.0 Operating System : Mac OSX Catalina v10.15.3 Experimental: Switched on Same JSON, schema processing fails or works depending on the order of the json elements: Fails: { "d…
Cannot Output Server Side Session Values Back to Client Side
I’ve just found that I cannot read the value of server action $_SESSION variables (which have the [ ] output option ticked) back on the client side any more. I’ve tried a million ways and they just do…
Server Action Set Value - Unexpected Behaviour
So I’m digging into larger server side actions for the first time, and have come up against some strange behaviour. I have a code structure like this: Set Value amount = value1 if condition A then …
Wappler 2.9.0 - If You Have a New Issue With Database Insert Not Recognising the Correct Column List
If you have an issue in 2.9.0 with the Database Insert server action not recognising the correct column list, try the following: Go to the Database Manager and hit the refresh icon (top right) for e…
Trying to troubleshoot the cause of 401 and 302 response codes executing server actions/.php pages
The problem we are seeing “sessions log out” - that is, a logged in user is performing continually performing operations/actions and at certain times, something occurs and the user is thrown back to t…
Will New Expression Format Expand to Database Actions?
Wappler 2.8.3 Am doing some database work and I notice that the new expression formatting is not being applied to Database Actions: So here I am trying to concatentate "Payment intent - " with the …
Expression Editor Creates Wrong Condition With a Count Aggregate In Server Step
Wappler 2.8.3 Windows 10 New expression editor is creating the wrong expression… here is my database query alias for price_count: and here is the equation created from it: Which should read: fe…
Clarity on Behaviour of Server Side $_SESSION variables
So my app is making different database calls and retrieving data that I don’t want to pass to the client side. I also don’t want to go to the database and retrieve any information more than once. He…
JSON Data API Action Not Working
Hello! I have been playing around with the JSON Data and I know it comes down to not inputting this correctly as I am able to get it working correctly in Postman. I have checked out quite a few posts…
Call a Stored Procedure from Custom Query Builder in SQL
I am trying to call a stored procedure that I didn’t write. It passes one variable in as @WorkOrderPK. I’m trying to figure out the correct parameters to pass this? This is the SQL stored Procedure…
Problems Using Catch/Response for an API
So I have an API which is throwing a 422 response that I want to tell my user about, but I cannot make the error message I am defining on the Server Side come through to the Client Side. Here is my s…
Correct Syntax to Base64 Encode a String Constant in Server Action Step
I need to base64 encode my username/password for authorisation to an api, and I want to be sure I have the syntax right. Would it be this? {{'myusername:mypassword'.encodeBase64()}} With the single…
Import from csv - only unique values
I’m making a csv import of products on palettes… I want it to insert data into two different tables - 1. all the products and 2. only unique palettes from that file. Step one works just fine but I’m …
Same HTML files but different database connections for subdomains
Hi guys, I would like to do the following thing, but I can not figure out how to do it: I am developing an application which has many users. Each user has their own separated MySQL database. I’d lik…
Caching strategies
Reading about caching strategies Cache first, Network fallback Network first, Cache fallback Cache/network race Network only Cache only Does Wappler enable the choice of these different strategi…
Server Action "Set Value"... Am I Doing Something Wrong?
Okay… so I am using a Server Action to add up how many times a table called brands is referenced in various other tables in my database. So to do this I have a Server Action which does a Set Value br…
How to Do A Database Count Through Records Containing Comma Separated Values?
I have a table of contacts, which have a field called contact_tags. Each tag recorded is the id from the table lookups. To keep things (possibly) easy, for each contact I’m just storing the contact_t…
Has anyone setup the "Stripe Checkout" not elements method of creating payment forms?
According to the stipe Website it is supposed to be quick and easy. Just starting out with all this I got lost know where it start. I was able to identify some of the items from some of the earlier St…
Coonection to Database
Hi, I’m struggling with the database connection to my MySql database. I keep getting errors and have followed all of the docs, and tutorials but I must be missing something. Most of the fixes in the r…
SSI File vs PHP Includes
Must all my HTML pages be converted to PHP for SSI includes to work in them? I’ve created a page with a header that includes a navbar and moved it to an include file (incl-header.html) and selected S…
Conditional based on serverconnect data - not filtering through all returned records, only the first record
So I’m showing a hidden component based on the user’s role. I have a condition that checks for a role value from a serverconnect search (wich uses the logged in user’s id). If the search retrieves mu…
Hi Wapplers
Making great progress creating Upload Single/Multiple Images even with a Dropzone. Wappler makes this super simple. Unfortunately I must have clicked on something by mistake because the Server Action …
Filter a Server Connect Query by Date Range Picker
I’m struggling to get a Server Connect query to filter by a date range. I have a range of filters, based on a drop down. When you select the Dates Between it triggers a Date Range Picker to filter the…
File Upload Fails Due to Permission Denied
Good Day Wappler Experts, Followed excellent step by step instructions here Uploading Single File To Your Server but upload fails due to Permission denied. Using phpMyAdmin on Cpanel Managed VPS Serv…
Do Database Query Server Actions Steps Run Sequentially?
I have two single database queries in a single server action. The search for the second one depends on data found in the first. Can I guarantee that the first query will complete before the second qu…
Serverconnect formatter not working on api-returned data
Problem is that PHP doesn’t really have objects, sometimes they are created as keyed arrays and sometimes they derive from the stdClass. An array is accessed as $item[$prop] and a class $item->$prop. …
500 - Internal server error on the SQL Database
I am not sure if anyone has encounter this error. I had to switch from a 2012 - 2018 ms web server recently. On the old server the database connection worked and the website worked great. Since swit…
ServerConnect SecurityLogin Unauthorized test
Hi, I am building a login form that locks the user after a number of failed attempts. For that I would like to capture the unahutorized event on the server side and increment a flag in the database …
Issue with Paged Query and Azure Database
I’m having an issue with running a paged query on my azure database. It works when there is no limit or offset and when there is just a limit, but when I try with a limit and offset it returns an erro…
Long server action freezes up the entire website
I have one server action that takes about 2 minutes, which is correct as far as I know. There’s a lot of steps it goes through. But during the running of this server action, no other traffic is possi…
Can we create server side custom formatters?
@George, I would like to create a simple server side formatter to generate random bytes. I added what I wanted to cypto_rules.js and crypto.php and the custom formatter displays in Wappler Editor and …
How Do I Create a Server Action Folder in the Root?
This is such a simple thing but seems to complex to do… When I already have lots of Server Action folders, how do I create a new one in the root of the structure? When I create a new folder it alway…
File Storage in Separate Data Store Area to App
As I plan the hosting of my app, I want to have a separate file store area to the where my code is hosted… I will probably use AWS and use EC2 for hosting the app, and S3 for hosting the files. The S…
Representing null in Server Action Condition
I have the following server action step: Is the the correct way to represent the value null?
Running a MySQL Batch File
So I’ve created loads of MySQL .sql files which create database tables, initiate values and define gzillions of stored procedures. Now I want to run them all in some kind of batch file on a new datab…
Database Query Sort
So I don’t know if this is a known issue or I am doing something wrong. But when you create a Database Query and you select* for all records in a table the Global Sort and Desc do not work. I have t…
[SOLVED] Textarea input in html email body
Trying to take a textarea input from a form and have it display WITH LINEFEEDS in an html email body, but can’t find the magic combination. I’ve tried “as-is” but everything displays on one line. Al…
Query Parameter From Modal Data
I’m sure I’ve missed something here, but I have a SELECT query which I’m attempting to constrain using a parameter. The parameter appears to pass through correctly, but the query returns all records, …
500 Internal Error on Submit
Hello, Please help. I have followed the instructions to create a form via bootstrap generator. When I submit the form I receive a 500 internal error.
Nedd help with "A session had already been started" error message
Getting this error message after adding Security Provider Enforcer on one of web page. can someone help me trouble shoot this?
Custom Query Parameter Not Working
I have created a ‘Database Custom Query’, and I need to order the results dynamically. Per my screenshots below, if I hardcode the ‘ORDER BY’ value into the query, the results return as expected. How…
Connecting to Azure SQL Server
Hi All, I have recently started work on a new site and have a Web App and SQL Server set-up on Azure. I am able to sync my site successfully to the Web App but I am unable to connect the SQL Server. …
Server action - convert json to array
Hi community, I have a nested json submitted to server-side by client-side form made up of hidden input fields. The format of the json is like this: myEmployees: [ { name: "John", role: "Ana…
Working with Database Queries in a multi-tenant web app
Hi, I am building a crm application that is using a multi-tenant single database (Azure SQL). I am trying to find the most efficient way to use the server side actions and database queries to ensure …
Published Site - How Are Database Connections Updated?
My local setup is with wamp, as my Windows 10 laptop does not support Docker Desktop. I’ve Published my site to a remote server, and all the PHP files have arrived safely. But I assume that my Databa…
Error 500 when deleting an Image
I’m following the YOUTUBE WAPPLER tutorial about “Creating an Image Gallery”. All is running pretty well but, when I arrived at video number 21 and I pressed the delete button in the photo (in this ca…
Php 7.2 get error with serverconnectForm.js try { this.xhr.send(data); }
php 7.2 get error with serverconnectForm.js Line 249 try { this.xhr.send(data); } reverted back to 7.1 php and working…
MySQL locks and transactions
Hello dear Wappler community superstars ! I was wondering if (My)SQL transactions and locks could be used within Wappler ? I can see that the syntax exists in the custom query autocomplete helper. …
Setting up Database Connection
Hi, I am trying to setup a connection to me DB, my setting look like this, I have obviously removed the actual details. I have installed SQL 2014 Management Studio and can access the DB and server…
Variable!
Hi Hi Can someone help me ? I have problem when I try to retrieve the value of the variable and write to Cookie.
Data - query - preview in browser problem
Hi all, I’m very fresh in Wappler, testing 3th day. Please does anyone have some experiences like this ? Happens when I want do display data query via Open in browser button - probably it is somehow …
Image upload and database troubleshoot
I need help identifying why my image process connection is not working correctly and why there is no record being created in my database table when I click upload image in my form.
I tried the two table method of security permissions but I am getting an error message
We are getting further, here a new update SecurityProvider.zip (12.6 KB)
Server side object variables in sessions
Is it possible to store an array of complex elements in a server side session variable? I can use Set Value to store the query results as desired, but I would like to store in a server side session…
Mailer - Bulk mailer and progress bar?
I have a mailing list of say 1000 emails… that needs to send out … the email is on a repeat query with serverconnect… … i will be using an external smtp server to send out the mails. If I press s…
How to update records, if they exist when importing CSV?
I often need to create facilities to upload CSV or tab files files to a server and import the data into MySQL tables. I usually use LOAD DATA LOCAL INFILE for this. It’s extremely fast and has some us…
Docker Setup - Access Denied for Database User
Hi all - I’m setting up my database connection using the cool new docker tools, but I get this error: Access denied for user ‘db_user’@‘172.19.0.3’ (using password: YES) Anyone know if this is someh…
Connecting to second sqlexpress database on different server
I am building a site that needs to also connect to a second sqlexpress database that is on another server. The second server is local to that network and on the same subnet and I have full control of…
Csv import - if more than 10k records i get error 500
Hi there, I just created a csv import in server side components: db connection import csv with a direct path to a file on the server (had it as upload before, now it is directly linked because i wa…
Having trouble testing FTP connection
Hi, I am new here! Sorry, if this is a dumb question. I have been struggling to get the FTP test connection to work. I have been using Namecheap to host the website. When I created the FTP account, I…
Security provider with api action
Hi, i want to create a login system but not based on database connection but on API Action; is that posible?
Dynamic Element (multiple phone numbers) in API Action
I’m working on a bulk SMS message. An API that send one message to multiple phone numbers. I have tried many different ways with no luck. I will show you a few of the ways I have tired. I’m sure t…
Cryptographic -> Encrypt with password: Technical details
Hi @patrick, can you please advise on the current implementation of the Mcrypt algorithm in Wappler? Are we using AES250? What is the maximum length of the password? What is the best way to store the…
Background jobs for asynchronously executing longer tasks
Hi everybody, Just wondering what is the right way to create a background jobs in Wappler. Let say a user press a button “Send confirmation link”. If I create a Server Action with Send Mail, the page…
Query returning no results
Hello! I am having a rather difficult time getting query results returned when using a WHERE condition and the database field is an INT. I’m trying to use a session variable which I have changed to bo…
Database Connection PHP
Hi, As per this post: I am getting the same error here. I have installed the extensions within wamp but I am still getting this error. Any help would be apprciated… Thanks Steve
Export to CSV : Data is not an array
Hello dear Wappler superstars ! Here is the use case I’d like to implement : Read CSV file Edit some values Write CSV file I’m currently blocked on export as the “export CSV” action in server conn…
Security Restrict not working for multiple permissions
Hi, What is the expected behavior when setting multiple permissions under the Security Restrict component ? Does the system authorize a user that have at least one of the permissions? I had assumed…
Help with form insert into database
Hi, I am a new user, I am loving this application however I am stuck. I am trying to do a simple insert query into database table. I have read other posts but no one seems to have the same error that …
I Cant connect to a Classic asp database connections (SQl Server)
i Cant Connet to a SQL database using Classic ASP, i tried to use relative and absolute path, nothing works, using PHP or ASP.NET proyects i can connect if change it from the proyect manager
Server side include (php include) - moves include out of <head>
this is now fixed in Wappler 2.1.6
Paging label not being displayed correctly
Please check the following topic and how the user resolved this issue caused by badly configured IIS settings: Problem with UTF-8 and German Umlauts on IIS
Why the need for comments in server-side includes?
Hi, I sometimes create a page and use a portion of that page (header, footer etc) to create an include-page. No problems. I might then change the name of the original file or delete it altogether but …
Google Cloud SQL
Hi Everyone, Quick question for the community. Has anyone tried connecting Wappler to Google Cloud MySql? Thanks, Ivan
Errors in Code View after enabling App Security Provider Enforcer
Hello @Teodor and @patrick, please see screenshot below in Code view upon enabling Security Provider Enforcer. It may not affect the code and functionality of the page, but this will affect how we c…
"Accessed JObject values with invalid key value" error when Permission is set
Hello, I am getting an error loading a page when Permission is configured with Security Restrict in Server Actions. Authentication is working. I can load the page if there is no permission configur…
Security Restrict Permissions help needed
I have set up a Server Action to list all the users in my database and I am populating a dropdown with the data. It works insofar as I get a list of all the users. What I am having trouble with is re…
SQL Express Connection
This is the first time I’ve setup a sql express connection. I have sql express 2017 installed on the same server as the IIS. So I’m a bit confused on setting up the connection. Its a bit different …
Problem sorting table columns
I noticed that some columns seem to sort unreliably in one or two tables I had created using the table generator. I examined one particular table; the correct ORDER BY clause was included in the quer…
Inserting form with conditional logic to multiple tables
I’m generating a Bootrstrap 4 from a database insert. That’s a great feature btw! Is it possible to add this logic to it? Make a select option available only when the difference between of two date …
Incorrect link when selecting Route via the GUI
Wappler Version: 2.1.5 Operating System: Windows 7 Expected behavior When assigning a route to a link via the Route dialog popup, it should maintain all properties of the route (slashes etc.) Actua…
Error Connecting to Remote Database
I am having problems connecting to a remote database. The ftp connection is working ok, but when I try to connect to a remote database I get the error message: Error using this database connection! …
Cannot access Connection properties to specify mysql server login
For the life of me I can’t get the Wappler 2.1.3 on my Mac to show the Connection Properties OPTIONS so that I can complete the connection. The online tutorials show different titles for some categor…
Error: Lexer Error: Unexpected token
With the latest Wappler updates, I keep getting error codes in my pages. The latest error is: “3603 javascript errors” EXAMPLES: Source: “dmxAppConnect.js:7” Message: “Error: Lexer Error: Unexpect…
Building multiple queries in Data bindings for MYSQL
I have an issue that I am trying to overcome. I have a button that I want to show when two queries meet a certain requirment. When a property l link is == certain condition and it runs the query fine…
Form to email action steps
I noticed that form field Post vars from a previous form (not the one currently being worked on) are listed. Also the same for setup mailer properties. Is this normal?
Form processing error
I have created a form, made it a server connect form, added the necessary set up mailer, send mail, saved the action file When I test the form by filling in the fields and hit send the form is emaile…
Wappler with Azure web app and sql database
Hi, I’m trying to set up a web app on azure. I have both a local and remote (Azure Web App) target in my Wappler project. Both are working and I can publish files to Azure via FTP. Where there’s no d…
Connect to MySQL via SSL
Hello, We have just set up a MySQL instance on Amazon Web Services and to connect to the database, I need to include a certificate (rds-combined-ca-bundle.pem). I could not see a place where I could…
Connecting to Azure SQL Database
Hello all. New Wappler user here. I’m trying to assess the feasibility of using this product to develop apps that are hosted in Azure App Service which utilize Azure SQL Database. I have set up the…
Unable to connect to remote mysql database: 404 Error!?!
Hello there, I’ve read the previous posts on this matter and sent support request to the hosting provider…but no solution so far. I can connect to MySQL via DbVisualizer, using the same connection p…
MySQL Database Error
I’m having issues getting my PHP website connected to a MySQL database. I followed the instructions online, have my website setup with an SFTP connection pointed to the correct folder. The website c…
Passing URL parameters to Routes?
Trying to pass a URL parameter to a route in a SPA, no values are going through
How To Create New Page Upon Click of a Button?
Hi, all. I am completely new to Wappler and trying to figure stuff out. Right now, I want to build an app and am trying to create to features and workflows necessary for that. The first one is: permit…
Variable and Server Conect
Hallo Wappler Team I made a Server Connect lg_select with colums from the Database lg_de and lg_fr and a Variable lg for change the content from de to fr. Now i like to mix the Server Connect with t…
Server connect - dynamic connections
Does anyone know of a way that variables being able to be used for the connection parameters in Server Connect? I have a database that contains the connection details for customers’ own databases whe…
Sum value not showing in query
I’m trying to create a query that will display a sum total of “points” by “team”. I made a server action query and connected it to a page with a responsive table When I add SUM in the aggregate the …
How to trigger app connect action based on server connect catch or else step?
For example, in server connect step, else, trigger dmx-show.
Upload file on ../ folder (outside site root folder)
Hi @Teodor I’m experiencing a problem. I have to upload files outside the folder where the application of wappler is done. It means that i should upload file to folder: …/foldername . but it seems…
SQL Database Connection Linked File - Security Concern
Hi Wappler team, I was having a look at the action connection file that is created in ..\dmxConnect\modules\Connections\connection1.php when the link icon is clicked: and I noticed the credentials…
Registration form not working
unable to get form working at : https://www.odessaantiqueshow.ca/register.php i enabled bug reporting and output ans still getting 400 error bad request on developer tools see screenshot
Few bugs in query builder
Hi, When I remove a table from the table list, wappler removes the selected columns but doesn’t delete the conditions, the only way to get rid of the old conditions is to add the table and columns …
Comparing 2 MySQL table with Server Connect
Hi everybody, I m so sorry these week I din t follow properly the forum but I had to work (sometimes happens) I got a problem that I think I can solve in wappler but because I’m not so good in Condi…
Blank API ACTION query parameters
Hi @George I make a API ACTION for connect to amazon mws I insert query parameters but the API ACTION doesn’t reuse there in Api Schema Editor Is’t normal ???
Server disconnects with any changes to the design?
I changed from TEXT to NUMBER, and could not get the data to load in the view. When one makes changes on the right side (design) and for some reason, the connection is no longer active how can one re…
Update database table form not working
Have followed the ‘Creating an database table update form using bootstrap generator and server connect’ but the resulting page does not update the mySQL database table. I’m using Wappler 1.7.1 and PH…
Different Result for Query on Server & Wappler
Hi, On executing a query made entirely from Server Connect Database Query, the result shown in JSON is incorrect. When I run the exact same query on the database directly, the result has 18 rows. But…
Pass to php file
Hi Ben, very nice of you to help me. Since it’s passing through the data to a .php file, I thought this was separate from databases. What should I do exactly ? If you can point me to a video that e…
Field/column of a database table
How can I select a single column from a table, when using expressions? {{table}} is the only thing I can select in expressions, but I want something like {{table.userid}} - userid being a column in t…
Cannot view results of database query in Browser
instead of viewing my database query results in the Browser, the Open in Browser options trys to download a .json file.
Server Connect Set Value
Hi, How do I set a value in a step using the results of a Database Query
Auto insert foreign key
Hi guys I have a table 1 with columns employee_id(primary key), employee_name, address. Table 2 has columns ID(primary key), employee_id(foreign key), pettycash_amount, date_received. In wappler i …
Error when getting record by security provider
I have a server action with a query that is filtered by the Identity of the security provider. When logged in I get the following error. If I hard code the Identity (it is an int field in an MS SQL d…
MySql 8 or MariaDB 10.3.8 on Amazon AWS
Hi Guys, I need to use recursive CTE on one of my projects and it is only available on MySQL 8 and from MariaDB 10.2.2, so I created a database server on Amazon AWS, but I can’t connect to it from wa…
Database logic: Define foreign keys for having constistend data?
This is really DB related. Should I use the built in DB logic from mysql? I mean I could just design my tables without their relation, thats it. Example: I got a DB with: t_user t_images t_posts s…
$_POST value not added using Database Delete
Not a big problem, but it would be nice to have a post value added automatically, the same as with Database Update.
Update multiple Tables using one Mysql View
This week I‘ll do some tests with Mysql Updateform over multiple tables. Does it make sense to use a Mysql View or should I go with Server steps and pass the ForeignKey to the depending connected mysq…
Image won't update
ISSUE On this particular page, I have an insert statement that works beautifully. That statement inserts a photo along with a bunch of other items. On the Edit form, I have an update statement. I do…
Help on adding image path to database
I get it, I’m probably being obtuse here. But, can someone help me on how to add the image path to the database? I have an database insert that includes tons of info, including an image. The form i…
Multiple Update and Multiple Insert Bugs
This has been fixed in version 1.5.2
SQL Queries - Select TOP X
Is there a way in wappler to create a query like “Select TOP 10 from XYZ”. Some of my tables have thousands of entries so I don’t want to (or need to) retrieve all of the records. The only way I am ab…
How to Submit Usersignup & Classifieds on same time?
First a big thank you developers! This is an amazing product and its so smooth how well done wappler is! I know Dreamweaver with the old native extension with direct php code. But using JSON as a „Mid…
How to set database connection when host denies access from outside?
I’m ready to publish my website onto my server. The problem is, my hosting provider doesn’t allow access to the database from outside the server environment (security reasons). Basically, no problem s…
Check if file exists from app structure
Good day everybody! Is it possible to check from the app structure if a specific file exists? I have the following scenario: A table where every row has download links to one mp3 and one zip. I wan…
File upload form
Hi guys, I’m trying to create a form with file upload. But I just can’t get it to work. I created a temp folder in the project directory. I changed the upload_tmp_dir in php.ini to this folder and a…
Data query username and $Session_Name
Hi Trying to build a MYSQL query on a table to return data where the username = $SESSION_NAME, is this possible within wappler? so something like IF ‘username’ = ($_SESSION[‘username’]). Tried adju…
Server Connect: Dynamic input parameters
Hi guys, is it possible to dynamically change the sources used at the input parameters in the server connect options? I have a table with a filter for each column. What I want to do is to change the…
I had a perfectly working backend until server switch
Hey guys, That’s a long discussion here glad you found the issue. As a conclusion I’d like to add: Date format in date field in myslq table is always an ISO date yyyy-mm-dd and it doesn’t matter …
Filters for ids
Since you no longer have the option “contains”, the ID is now required. I do not want to make this compulsory, What should I do ? in dreamweaver we could choose.
Help: UserId and Detail Page
Hello pros, I am trying to create a login.html page that will pass user’s details to a emply_brief.php based on the userID setup in the security provider. I have followed all the steps, but not knowi…
Return Formatted page with data from 1 record
Trying to get something to work that I assume should be easy but I can’t figure out how to get it to work. I am trying to create a Work Order page from my job database. All of the info is contained i…
Advanced conditional Server Connect actions
Sometimes I have some pretty complicated server action files with a couple of nested levels to get to my result. Probably I’m not a good database designer or maybe I’m overcomplicating the structure, …
What .net do you support?
Hi. Is it .net classic? .net framework 4.x or .net core? I’d love it to be .net core benifiting from .net core can run on Windows and Mac
SQLSTATE[HY000]: General error: 1364 Field 'file' doesn't have a default value"
upload form was working fine but now I get a SQLSTATE[HY000]: General error: 1364 Field ‘file’ doesn’t have a default value".
MySQL Subquery in Query Builder
Hi Everybody, I m not a so big expert then maybe I m asking something easy, but I don’t find a solution. I have two tables in MySQL db I used to give access to other lists to the clients. First tab…
Problem/bug using 'IN' in query builder
If a comma-separated list of numbers is entered as a search parameter using the ‘IN’ operator in query builder, Wappler surrounds the list in single quotes. As a result the query will fail (it will re…
VIDEO: Multiple Bugs when making changes Database Tables in Security Provider(permissions)
bug.mp4 (33.6 MB) VIDEO: Multiple Bugs when making changes Database Tables in Security Provider(permissions. Database is empty when trying to change or ad details, and wont save. See video.
Server Side Components in ASP.NET
While during my beta testing, I could only get it to run on one machine, you have fixed that issue and I am able to run on my development machine. You have a great product. Just looking at the free …
Target not connecting
While trying to resolve another issue 2 of my test sites will no longer connect via ftp to their target I get this error the exact same details connect in Dreamweaver Using with passive checked …
Bootstrap form generator issue
Hi All Sorry, starting to feel like the needy kid on the block but after another day of failed tries i have to ask again I am trying to create a bootstrap update from using generator After several …
Firebase Cloud or Mongo DB
Wappler supports JSON from local document… Can I connect to Firebase or Mongo DB
Select Server model in Mobile App Type in to the proyect settings
how i select the server side model in a mobile proyect to get data from a server, where are localted the server side files in the proyect folder?
MySQL/PHP Database Connection
Just a simple question, which PHP ‘protocol’ does Wrappler use to connect to a MySQL Database, mysql, mysql or PDO. It looks from the generated code to be PDO, but I am not sure.
Bug Report from gregg #2018-5-19_17-23-0
OS info Operating System : Mac OSX 17.6.0 Wappler Version : 1.0.3 Problem description Attempting to create a database connection Steps to reproduce Create Database connection Target set to Test…
Site Security SHA-1 or MD5
Hi there I’m now full-on with developing a new site to replace one I built some years ago with Dreamweaver. I’m using the same database and am currently working through the security provider extensio…
How to join firstname and lastname
I would like to have a database query that combines both names similar to SELECT *, UserFirstname + ’ ’ + UserLastName AS UserFullName FROM users WHERE UserID = :security_identity In other words, a …