gypsybytes
Forum Replies Created
-
Forum: Plugins
In reply to: [Enable Media Replace] Version 4 – Cannot replace pdfI’m having the same problem trying to replace a zip file. I’m running the latest versions of WordPress and the plugin on Chrome on Windows 10.
I get these error messages, but am able to replace the file successfully:
The replacement file does not have the same file type. This can lead to unexpected issues ( – application/x-zip-compressed )
The replacement file type does not seem to be allowed by WordPress. This can lead to unexpected issues@peterschulznl thanks for the info on how to CONCAT an URL .. I do have an URL in one of my views .. it is in its own column and I defined that column as a hyperlink and that works, but I’m going to try what you’ve explained above.
PS I’m happy to help where I can 🙂 It’s the least I can do to show my appreciation for all your hard work. I’m in South Africa and my currency is worth nothing compared to yours, so making a worthwhile donation is not really feasible. I think one of my Rands is 5c in Euros .. I’ll need a bank loan just to buy you a cup of coffee .. hahahaha
I created your table on my database and ran your script without any changes in WPDA and it worked. Remember I told you that you must have a blank new line at the end.
CREATE VIEW bk_weg_view AS SELECT W.weg_bezeichnung ,W.nlp_bereich ,CONCAT('http://www.openstreetmap.org/?mlat=',W.start_gps_breite,'&mlon=',W.start_gps_laenge,'&zoom=15&layers=M') AS osm_link ,W.start_gps_breite ,W.start_gps_laenge ,W.end_gps_breite ,W.end_gps_laenge FROM bk_weg_db AS W;the name in your FROM .. bk_weg_db .. is that a table name or a database name? It must be a table name. I ask because it has _db on the end, so it looks like a database name.
FROM bk_weg_db AS W;oh great .. well you need to write the sql script to create the view and then you have to execute the script in either Data Explorer or Data Designer .. there is a button called “Import data/Execute script(s)”
Here is an example of a very simple script I wrote:
CREATE VIEW tcsa_v_committee AS SELECT C.committee_portfolio , CONCAT(L.leader_firstname,' ',L.leader_lastname) AS v_fullname , L.leader_phone_main , L.leader_email FROM tcsa_committee AS C INNER JOIN tcsa_leader AS L USING (leader_id) ORDER BY committee_display_order ASC;I have two tables called tcsa_committee (which has the committee positions) and I have tcsa_leader which has people in it and some of them are on the committee. I am creating the view tcsa_v_committee which has the committee positions with the leader’s names and other details and in the order in which I want the committee displayed in the table.
Make sure your CREATE VIEW sql script ends with a ; and that you have a blank new line at the end or it will not work in WPDA.
Hope that helps.
Bernd, you have to know how to write some sql code and you probably will not be able to do it if you are a beginner. Do you happen to have a friend who is a coder who can take a look at what you’re trying to do and can write the sql script for you?
Ahhhh! I had the semi-colon, but did not realise I needed a new line after .. it works now.
Thanks for the quick response.
Yes, it’s possible Bernd.
You have to create a view and do all the calculations and concatenations of the various bits and pieces in the select statement to create the fields you need. You then display this view on your page.
Kind regards
Melody